DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_ELEMENT_TYPES_F

Line 1690: from pay_element_types_f pet,

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

Line 5388: pay_element_types_f pet

5384: end if;
5385: select 1
5386: into dummy
5387: from pay_payroll_actions pac,
5388: pay_element_types_f pet
5389: where pac.payroll_action_id = pactid
5390: and pet.element_type_id = etypid
5391: and pac.effective_date between
5392: pet.effective_start_date and pet.effective_end_date;

Line 5659: PET PAY_ELEMENT_TYPES_F_PK,

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

Line 5673: pay_element_types_f pet

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