DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 581: pay_assignment_actions paa,

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