DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_RUN_RESULTS

Line 2402: ,pay_run_results prr

2398: decode(pee.creator_type,
2399: 'EE',pee.source_end_date,
2400: 'RR',rr_ret.end_date) retro_pro_end
2401: from pay_run_result_values prrv
2402: ,pay_run_results prr
2403: ,pay_element_types_f pet
2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric

Line 2416: ,pay_run_results rr_ret

2412: ,pay_assignment_actions run_assact
2413: ,pay_action_interlocks arc_lock
2414: ,pay_action_interlocks pre_lock
2415: ,pay_element_entries_f pee
2416: ,pay_run_results rr_ret
2417: where pee.element_entry_id(+) = prr.source_id
2418: and rr_ret.run_result_id(+) = pee.source_id
2419: and prrv.run_result_id = prr.run_result_id
2420: and prr.element_type_id = pet.element_type_id

Line 3022: ,pay_run_results prr

3018: ,nvl(user_rubric.tag,seed_rubric.tag) Rubric
3019: ,nvl(user_rubric.meaning,seed_rubric.meaning) Description
3020: ,base_units.meaning BASE_UNITS
3021: from pay_element_types_f pet
3022: ,pay_run_results prr
3023: ,pay_input_values_f piv
3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric
3026: ,fnd_lookup_values seed_rubric

Line 3577: ,pay_run_results prr

3573: ,g_ele_class_Income_Tax_Excess ,'CONTRIBUTIONS_TAX') elecls
3574: ,ptp_date.start_date ptp_start_date
3575: ,ptp_date.end_date ptp_end_date
3576: from pay_run_result_values prrv
3577: ,pay_run_results prr
3578: ,pay_element_types_f pet
3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact