APPS.HRASSACT dependencies on PAY_ELEMENT_LINKS_F

Line 1723: pay_element_links_f pel,

1719: pee.updating_action_id,
1720: pee.effective_start_date,
1721: pee.effective_end_date
1722: from pay_element_types_f pet,
1723: pay_element_links_f pel,
1724: pay_element_entries_f pee
1725: where pee.assignment_id = p_assact_rec.assignment_id
1726: and pee.entry_type = 'E'
1727: and p_pact_rec.action_date between

Line 3083: ,pay_element_links_f pel

3079: hr_utility.set_location('hrassact.del_latest_balances',60);
3080: end if;
3081: select pel.element_type_id into l_element_type_id
3082: from pay_element_entries_f pee
3083: ,pay_element_links_f pel
3084: where
3085: pee.element_entry_id = p_element_entry
3086: and p_effective_date between pee.effective_start_date
3087: and pee.effective_end_date

Line 5922: PEL PAY_ELEMENT_LINKS_F_PK,

5918: ) is
5919: cursor c1 is
5920: select + ORDERED
5921: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK,
5922: PEL PAY_ELEMENT_LINKS_F_PK,
5923: PET PAY_ELEMENT_TYPES_F_PK,
5924: ACT2 PAY_ASSIGNMENT_ACTIONS_PK)
5925: USE_NL(PAC ACT PAI ACT2 RR2 PEE)
5926: pet.element_type_id,

Line 5936: pay_element_links_f pel,

5932: pay_action_interlocks pai,
5933: pay_assignment_actions act2,
5934: pay_run_results rr2,
5935: pay_element_entries_f pee,
5936: pay_element_links_f pel,
5937: pay_element_types_f pet
5938: where pac.payroll_action_id = p_payroll_action_id
5939: and act.payroll_action_id = pac.payroll_action_id
5940: and pee.assignment_id = act.assignment_id