DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 525: from pay_assignment_actions paa,pay_payroll_actions ppa

521: select nvl(paa.serial_number,'-9999'),
522: substr(fnd_date.date_to_canonical(ppa.effective_date),1,10),
523: substr(nvl(fnd_date.date_to_canonical(ppa.overriding_dd_date),fnd_date.date_to_canonical(ppa.effective_date)),1,10),
524: ppa.payroll_action_id
525: from pay_assignment_actions paa,pay_payroll_actions ppa
526: where paa.assignment_action_id = p_asg_act
527: and paa.payroll_action_id=ppa.payroll_action_id;
528:
529:

Line 582: ,pay_assignment_actions paa

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
586: and pai.locked_action_id=paa.assignment_action_id