DBA Data[Home] [Help]

APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 423: from pay_payroll_actions ppa

419: CURSOR csr_max_action_seq (p_assignment_id number,
420: p_date date)
421: IS
422: select max(pac.action_sequence)
423: from pay_payroll_actions ppa
424: ,pay_assignment_actions pac
425: where ppa.payroll_action_id = pac.payroll_action_id
426: and pac.assignment_id = p_assignment_id
427: and ppa.effective_date <= p_date