DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 579: pay_assignment_actions paa,

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
583: AND ppa.payroll_id = l_payroll_id