APPS.HRASSACT dependencies on PAY_ELEMENT_LINKS_F

Line 1691: pay_element_links_f pel,

1687: pee.updating_action_id,
1688: pee.effective_start_date,
1689: pee.effective_end_date
1690: from pay_element_types_f pet,
1691: pay_element_links_f pel,
1692: pay_element_entries_f pee
1693: where pee.assignment_id = p_assact_rec.assignment_id
1694: and pee.entry_type = 'E'
1695: and p_pact_rec.action_date between

Line 3066: ,pay_element_links_f pel

3062: hr_utility.set_location('hrassact.del_latest_balances',60);
3063: end if;
3064: select pel.element_type_id into l_element_type_id
3065: from pay_element_entries_f pee
3066: ,pay_element_links_f pel
3067: where
3068: pee.element_entry_id = p_element_entry
3069: and p_effective_date between pee.effective_start_date
3070: and pee.effective_end_date

Line 5658: PEL PAY_ELEMENT_LINKS_F_PK,

5654: ) is
5655: cursor c1 is
5656: select + ORDERED
5657: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK,
5658: PEL PAY_ELEMENT_LINKS_F_PK,
5659: PET PAY_ELEMENT_TYPES_F_PK,
5660: ACT2 PAY_ASSIGNMENT_ACTIONS_PK)
5661: USE_NL(PAC ACT PAI ACT2 RR2 PEE)
5662: pet.element_type_id,

Line 5672: pay_element_links_f pel,

5668: pay_action_interlocks pai,
5669: pay_assignment_actions act2,
5670: pay_run_results rr2,
5671: pay_element_entries_f pee,
5672: pay_element_links_f pel,
5673: pay_element_types_f pet
5674: where pac.payroll_action_id = p_payroll_action_id
5675: and act.payroll_action_id = pac.payroll_action_id
5676: and pee.assignment_id = act.assignment_id