APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_ELEMENT_ENTRIES_F

Line 2720: ,pay_element_entries_f pee

2716: FROM per_all_assignments_f paa
2717: ,per_periods_of_service pps
2718: ,pay_assignment_actions pac
2719: ,pay_payroll_actions ppa
2720: ,pay_element_entries_f pee
2721: ,pay_run_results prr
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad

Line 2765: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,

2761: AND ppa.date_earned between piv.effective_start_date and piv.effective_end_date
2762: ;
2763:
2764:
2765: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,
2766: c_balance_type_id pay_defined_balances.defined_balance_id%type)
2767: IS
2768: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
2769: ,prv.result_value balance_value

Line 2771: pay_element_entries_f pee,

2767: IS
2768: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
2769: ,prv.result_value balance_value
2770: from
2771: pay_element_entries_f pee,
2772: pay_run_results prr,
2773: pay_run_result_values prv,
2774: pay_element_types_f pet,
2775: pay_balance_types pbt

Line 3310: , pay_element_entries_f pee

3306: from pay_balance_types pbt
3307: , pay_balance_feeds_f pbf
3308: , pay_input_values_f piv
3309: , pay_element_types_f pet
3310: , pay_element_entries_f pee
3311: , pay_element_links_f pel
3312: , per_all_people_f pap
3313: , per_periods_of_service pps
3314: , per_all_assignments_f paa

Line 4939: , pay_element_entries_f pee

4935: from pay_balance_types pbt
4936: , pay_balance_feeds_f pbf
4937: , pay_input_values_f piv
4938: , pay_element_types_f pet
4939: , pay_element_entries_f pee
4940: , pay_element_links_f pel
4941: , per_all_people_f pap
4942: , per_periods_of_service pps
4943: , per_all_assignments_f paa

Line 5175: pay_element_entries_f pee,

5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,
5174: pay_element_links_f pel,
5175: pay_element_entries_f pee,
5176: pay_element_entry_values_f pev,
5177: per_all_assignments_f paa,
5178: per_all_people_f pap,
5179: per_addresses pad,

Line 7252: pay_element_entries_f pee,

7248: from
7249: pay_element_types_f pet,
7250: pay_input_values_f piv,
7251: pay_element_links_f pel,
7252: pay_element_entries_f pee,
7253: pay_element_entry_values_f pev
7254: where pet.element_name = 'Tax Information'
7255: and piv.name = 'Tax File Number'
7256: and pet.element_type_id = piv.element_type_id

Line 9650: ,pay_element_entries_f pee

9646: FROM per_all_assignments_f paa
9647: ,per_periods_of_service pps
9648: ,pay_assignment_actions pac
9649: ,pay_payroll_actions ppa
9650: ,pay_element_entries_f pee
9651: ,pay_run_results prr
9652: ,pay_run_result_values prv
9653: ,pay_element_types_f pet
9654: ,pay_input_values_f piv