APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 402: pay_payroll_actions ppa,

398: ppa.date_earned,
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;

Line 416: pay_payroll_actions ppa,

412: pec.legislation_code
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

Line 431: pay_payroll_actions ppa2,

427: from pay_input_values_f piv,
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

Line 433: pay_payroll_actions ppa,

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
437: and ppa.action_type='I'

Line 512: pay_payroll_actions ppa

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
516: when others then