DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 581: from pay_action_interlocks pai

577:
578: CURSOR csr_get_time_period(p_asg_act_id in number)
579: is
580: select min(ptp.start_date),max(ptp.end_date), max(paa.assignment_Action_id)
581: from pay_action_interlocks pai
582: ,pay_assignment_actions paa
583: ,pay_payroll_actions ppa
584: ,per_time_periods ptp
585: where p_asg_act_id=pai.locking_action_id