DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PER_TIME_PERIODS

Line 584: ,per_time_periods ptp

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
586: and pai.locked_action_id=paa.assignment_action_id
587: and paa.source_action_id is null
588: and ppa.payroll_action_id = paa.payroll_action_id