APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 437: pay_assignment_actions paa

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;
441: */

Line 451: pay_assignment_actions paa

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
455: and pet.element_type_id=prr.element_type_id

Line 466: pay_assignment_actions paa2,

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
470: and ppa.payroll_action_id=paa.payroll_action_id

Line 468: pay_assignment_actions paa

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'
472: and paa2.assignment_id=paa.assignment_id

Line 545: from pay_assignment_actions paa,

541: -- l_date_earned,
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