APPS.PSP_ENC_LIQ_TRAN dependencies on PAY_PAYROLL_ACTIONS

Line 578: FROM pay_payroll_actions ppa,

574:
575: /* Bug 5642002: Replaced earned date with period end date */
576: CURSOR payroll_run_date_cur IS
577: SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
578: FROM pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp
581: WHERE ppa.payroll_action_id = paa.payroll_action_id
582: and ppa.business_group_id = g_bg_id

Line 596: FROM pay_payroll_actions ppa

592: FROM per_time_periods
593: WHERE end_date = l_payroll_run_date
594: /***** Commented for bug fix 4625734
595: (SELECT MAX(date_earned)
596: FROM pay_payroll_actions ppa
597: WHERE ppa.business_group_id = p_business_group_id
598: AND payroll_id = pec.payroll_id
599: AND action_type = 'R'
600: AND action_status = 'C')

Line 838: from pay_payroll_actions

834: /* Commented for bug 2259310 *******
835: (select max(time_period_id) from per_time_periods
836: --for bug fix 1971612 where end_date = (select max(effective_date)
837: where end_date = (select max(date_earned)
838: from pay_payroll_actions
839: where business_group_id = g_bg_id
840: -- and set_of_books_id = g_sob_id
841: -- above commented out as there is no set of books column
842: -- in pay_payroll_actions will go as part of bug 1971612

Line 842: -- in pay_payroll_actions will go as part of bug 1971612

838: from pay_payroll_actions
839: where business_group_id = g_bg_id
840: -- and set_of_books_id = g_sob_id
841: -- above commented out as there is no set of books column
842: -- in pay_payroll_actions will go as part of bug 1971612
843: and payroll_id = p_payroll_id
844: and action_type = 'R'
845: and action_status = 'C')
846: and payroll_id = p_payroll_id);

Line 878: from pay_payroll_actions

874: /* Commented for bug 2259310 *****************************************
875: (select max(time_period_id) from per_time_periods
876: --for bug fix 1971612 where end_date = (select max(effective_date)
877: where end_date = (select max(date_earned)
878: from pay_payroll_actions
879: where business_group_id = g_bg_id
880: -- and set_of_books_id = g_sob_id
881: -- above commented out as there is no set of books column
882: -- in pay_payroll_actions, will go as part of bug 1971612

Line 882: -- in pay_payroll_actions, will go as part of bug 1971612

878: from pay_payroll_actions
879: where business_group_id = g_bg_id
880: -- and set_of_books_id = g_sob_id
881: -- above commented out as there is no set of books column
882: -- in pay_payroll_actions, will go as part of bug 1971612
883: and payroll_id = p_payroll_id
884: and action_type = 'R'
885: and action_status = 'C')
886: and payroll_id = p_payroll_id);