APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 512: FROM pay_payroll_actions ppa

508:
509: CURSOR get_payroll_details(p_prepru_pact_id in number)
510: IS
511: SELECT ppa.start_date
512: FROM pay_payroll_actions ppa
513: , pay_payrolls_f pp
514: WHERE ppa.payroll_action_id = p_prepru_pact_id
515: and pp.payroll_id = ppa.payroll_id
516: and ppa.effective_date between pp.effective_start_date

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 583: ,pay_payroll_actions ppa

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
587: and paa.source_action_id is null