DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_ELEMENT_TYPES_F

Line 1722: from pay_element_types_f pet,

1718: pee.element_entry_id,
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'

Line 5624: pay_element_types_f pet

5620: end if;
5621: select 1
5622: into dummy
5623: from pay_payroll_actions pac,
5624: pay_element_types_f pet
5625: where pac.payroll_action_id = pactid
5626: and pet.element_type_id = etypid
5627: and pac.effective_date between
5628: pet.effective_start_date and pet.effective_end_date;

Line 5923: PET PAY_ELEMENT_TYPES_F_PK,

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,
5927: act.assignment_action_id,

Line 5937: pay_element_types_f pet

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
5941: and pai.locking_action_id = act.assignment_action_id