DBA Data[Home] [Help]

APPS.PQP_EXPPREPROC_PKG dependencies on PER_TIME_PERIODS

Line 120: per_time_periods ptp

116: FROM per_assignments_f asg,
117: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
118: pay_assignment_actions act_run, /* run and quickpay assignment actions */
119: pay_payroll_actions ppa_gen, /* PYUGEN information */
120: per_time_periods ptp
121: WHERE ppa_gen.payroll_action_id = pactid
122: --Added by Gattu
123: AND ptp.payroll_id = nvl(l_payroll_id,
124: ppa_run.payroll_id)

Line 183: per_time_periods ptp

179: FROM per_assignments_f asg,
180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
181: pay_assignment_actions act_run, /* run and quickpay assignment actions */
182: pay_payroll_actions ppa_gen, /* PYUGEN information */
183: per_time_periods ptp
184: WHERE ppa_gen.payroll_action_id = pactid
185: --Added by Gattu
186: AND ptp.payroll_id = l_payroll_id
187: AND (ppa_run.effective_date BETWEEN ptp.start_date AND