DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_RUN_RESULTS

Line 485: pay_run_results prr ,

481: pet.processing_priority
482: from pay_assignment_actions paa ,
483: pay_assignment_actions paa1 ,
484: pay_payroll_actions ppa ,
485: pay_run_results prr ,
486: pay_element_types_f pet ,
487: pay_element_classifications pec
488: where paa.assignment_action_id = cp_assignment_action_id
489: and paa1.assignment_id = paa.assignment_id

Line 531: pay_run_results prr,

527: pet.business_group_id,
528: pec.classification_name,
529: pet.processing_priority
530: from pay_element_entries_f pee,
531: pay_run_results prr,
532: pay_element_types_f pet,
533: pay_element_classifications pec
534: where pee.assignment_id = cp_assignment_id
535: --and pee.effective_end_date >= trunc(cp_date_earned, 'Y')

Line 2674: pay_run_results prr ,

2670: pet.processing_priority
2671: from pay_assignment_actions paa ,
2672: pay_assignment_actions paa1 ,
2673: pay_payroll_actions ppa ,
2674: pay_run_results prr ,
2675: pay_element_types_f pet ,
2676: pay_element_classifications pec
2677: where paa.assignment_action_id = cp_assignment_action_id
2678: and paa1.assignment_id = paa.assignment_id

Line 2704: pay_run_results prr,

2700: pet.element_information10,
2701: pet.business_group_id,
2702: pet.processing_priority
2703: from pay_element_entries_f pee,
2704: pay_run_results prr,
2705: pay_element_types_f pet,
2706: pay_element_classifications pec
2707: where pee.assignment_id = cp_assignment_id
2708: and pee.effective_end_date >= trunc(cp_date_earned, 'Y')