APPS.PSP_ENC_LIQ_TRAN dependencies on PAY_PAYROLL_ACTIONS

Line 580: FROM pay_payroll_actions ppa,

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

Line 598: FROM pay_payroll_actions ppa

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

Line 840: from pay_payroll_actions

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

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

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

Line 880: from pay_payroll_actions

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

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

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