APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 436: pay_payroll_actions ppa,

432: ppa.date_earned,
433: paa.assignment_id,
434: ppa.effective_date
435: from pay_element_sets pes,
436: pay_payroll_actions ppa,
437: pay_assignment_actions paa
438: where paa.assignment_action_id=p_assignment_action_id
439: and ppa.payroll_action_id=paa.payroll_action_id
440: and pes.element_set_id(+)=ppa.element_set_id;

Line 450: pay_payroll_actions ppa,

446: pec.legislation_code
447: from pay_element_classifications pec,
448: pay_element_types_f pet,
449: pay_run_results prr,
450: pay_payroll_actions ppa,
451: pay_assignment_actions paa
452: where paa.assignment_action_id=p_assignment_action_id
453: and ppa.payroll_action_id=paa.payroll_action_id
454: and prr.assignment_action_id=paa.assignment_action_id

Line 465: pay_payroll_actions ppa2,

461: from pay_input_values_f piv,
462: pay_element_types_f pet,
463: pay_run_result_values prrv,
464: pay_run_results prr,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa2,
467: pay_payroll_actions ppa,
468: pay_assignment_actions paa
469: where paa.assignment_action_id=p_assignment_action_id

Line 467: pay_payroll_actions ppa,

463: pay_run_result_values prrv,
464: pay_run_results prr,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa2,
467: pay_payroll_actions ppa,
468: pay_assignment_actions paa
469: where paa.assignment_action_id=p_assignment_action_id
470: and ppa.payroll_action_id=paa.payroll_action_id
471: and ppa.action_type='I'

Line 546: pay_payroll_actions ppa

542: l_assignment_id,
543: l_element_set_id,
544: l_element_type_id
545: from pay_assignment_actions paa,
546: pay_payroll_actions ppa
547: where paa.assignment_action_id = p_assignment_action_id
548: and ppa.payroll_action_id = paa.payroll_action_id;
549: exception
550: when others then