APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 403: pay_assignment_actions paa

399: paa.assignment_id,
400: ppa.effective_date
401: from pay_element_sets pes,
402: pay_payroll_actions ppa,
403: pay_assignment_actions paa
404: where paa.assignment_action_id=p_assignment_action_id
405: and ppa.payroll_action_id=paa.payroll_action_id
406: and pes.element_set_id(+)=ppa.element_set_id;
407: */

Line 417: pay_assignment_actions paa

413: from pay_element_classifications pec,
414: pay_element_types_f pet,
415: pay_run_results prr,
416: pay_payroll_actions ppa,
417: pay_assignment_actions paa
418: where paa.assignment_action_id=p_assignment_action_id
419: and ppa.payroll_action_id=paa.payroll_action_id
420: and prr.assignment_action_id=paa.assignment_action_id
421: and pet.element_type_id=prr.element_type_id

Line 432: pay_assignment_actions paa2,

428: pay_element_types_f pet,
429: pay_run_result_values prrv,
430: pay_run_results prr,
431: pay_payroll_actions ppa2,
432: pay_assignment_actions paa2,
433: pay_payroll_actions ppa,
434: pay_assignment_actions paa
435: where paa.assignment_action_id=p_assignment_action_id
436: and ppa.payroll_action_id=paa.payroll_action_id

Line 434: pay_assignment_actions paa

430: pay_run_results prr,
431: pay_payroll_actions ppa2,
432: pay_assignment_actions paa2,
433: pay_payroll_actions ppa,
434: pay_assignment_actions paa
435: where paa.assignment_action_id=p_assignment_action_id
436: and ppa.payroll_action_id=paa.payroll_action_id
437: and ppa.action_type='I'
438: and paa2.assignment_id=paa.assignment_id

Line 511: from pay_assignment_actions paa,

507: -- l_date_earned,
508: l_assignment_id,
509: l_element_set_id,
510: l_element_type_id
511: from pay_assignment_actions paa,
512: pay_payroll_actions ppa
513: where paa.assignment_action_id = p_assignment_action_id
514: and ppa.payroll_action_id = paa.payroll_action_id;
515: exception