DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PAY_RUN_RESULTS

Line 1181: pay_run_results prr,

1177: select /*+ ORDERED */
1178: pec.classification_name
1179: from pay_assignment_actions paa,
1180: pay_payroll_actions ppa,
1181: pay_run_results prr,
1182: pay_element_types_f pet,
1183: pay_element_classifications pec
1184: where paa.assignment_action_id = p_assignment_action_id
1185: and ppa.payroll_action_id = paa.payroll_action_id

Line 4019: pay_run_results prr,

4015: and hoi2.org_information3 = 'IV'
4016: and fnd_number.canonical_to_number(hoi2.org_information1) = p_data_ass_payroll_id
4017: and fnd_number.canonical_to_number(hoi2.org_information5) = fnd_number.canonical_to_number(hoi.org_information5)
4018: and hoi2.org_information_id > hoi.org_information_id)) target_iv,
4019: pay_run_results prr,
4020: pay_run_result_values prrv
4021: where prr.assignment_action_id = p_assignment_action_id
4022: and prr.element_type_id = target_iv.element_type_id
4023: and prrv.run_result_id = prr.run_result_id