APPS.PSP_ENC_CREATE_LINES dependencies on PAY_PAYROLL_ACTIONS

Line 466: FROM pay_payroll_actions ppa,

462: SELECT /*+ use_nl(PTP)
463: INDEX(ptp PER_TIME_PERIODS_N50)
464: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
465: Max(ptp.end_date)
466: FROM pay_payroll_actions ppa,
467: pay_assignment_actions paa,
468: per_time_periods ptp
469: WHERE paa.assignment_id = p_assignmnet_id
470: AND ppa.payroll_action_id = paa.payroll_action_id

Line 484: FROM pay_payroll_actions ppa

480: SELECT /*+ use_nl(PTP)
481: INDEX(ptp PER_TIME_PERIODS_N50)
482: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4)*/
483: max (ptp.end_date)
484: FROM pay_payroll_actions ppa
485: , pay_assignment_actions paa
486: , per_time_periods ptp
487: WHERE paa.assignment_id (+) = p_assignmnet_id
488: AND ppa.payroll_action_id = paa.payroll_action_id (+)

Line 567: FROM pay_payroll_actions ppa

563:
564: cursor payroll_pay_end_date_cur(p_payroll_id number) is
565: SELECT /*+ INDEX(ptp PER_TIME_PERIODS_N50)*/
566: max (ptp.end_date)
567: FROM pay_payroll_actions ppa
568: ,pay_assignment_actions paa
569: ,per_time_periods ptp
570: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
571: AND ppa.payroll_id = p_payroll_id

Line 6907: SELECT /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N51)

6903:
6904:
6905:
6906: CURSOR c_last_pay_run (p_assignment_id NUMBER)IS
6907: SELECT /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
6908: INDEX(ptp PER_TIME_PERIODS_N50) */
6909: Max(ptp.end_date)
6910: FROM pay_payroll_actions ppa,
6911: pay_assignment_actions paa,

Line 6910: FROM pay_payroll_actions ppa,

6906: CURSOR c_last_pay_run (p_assignment_id NUMBER)IS
6907: SELECT /*+ INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
6908: INDEX(ptp PER_TIME_PERIODS_N50) */
6909: Max(ptp.end_date)
6910: FROM pay_payroll_actions ppa,
6911: pay_assignment_actions paa,
6912: per_time_periods ptp
6913: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
6914: AND ppa.business_group_id = l_business_group_id

Line 6950: FROM pay_payroll_actions

6946: AND pel.payroll_id = l_payroll_id;
6947:
6948: CURSOR cel_request_id_cur IS
6949: SELECT request_id
6950: FROM pay_payroll_actions
6951: WHERE payroll_action_id = p_payroll_action_id;
6952:
6953: CURSOR asg_number_cur (p_effective_date IN DATE) IS
6954: SELECT assignment_number,

Line 8854: FROM pay_payroll_actions ppa,

8850:
8851: /* Bug 5642002: Replaced earned date with period end date */
8852: CURSOR c_last_pay_run IS
8853: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8854: FROM pay_payroll_actions ppa,
8855: pay_assignment_actions paa,
8856: per_time_periods ptp
8857: WHERE ppa.payroll_action_id = paa.payroll_action_id (+)
8858: AND ppa.business_group_id = l_business_group_id

Line 9457: INDEX(ppa PAY_PAYROLL_ACTIONS_N51)

9453: AND pesl.payroll_id = pa.payroll_id -- Added for bug 9862281
9454: AND pesl.status_code IN ('A', 'N')
9455: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
9456: AND pesl.effective_date > (NVL((SELECT /*+
9457: INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
9458: INDEX(ptp PER_TIME_PERIODS_N50)
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,

Line 9461: FROM pay_payroll_actions ppa,

9457: INDEX(ppa PAY_PAYROLL_ACTIONS_N51)
9458: INDEX(ptp PER_TIME_PERIODS_N50)
9459: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N4) */
9460: Max(ptp.end_date)
9461: FROM pay_payroll_actions ppa,
9462: per_time_periods ptp,
9463: pay_assignment_actions paa
9464: WHERE paa.assignment_id(+) = pesl.assignment_id
9465: AND ppa.payroll_action_id = paa.payroll_action_id (+)