DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 115: from pay_element_types_f pet,

111: -- and pee.creator_type <> 'A' -- Bug 4422696
112: and pee.creator_type not in('A','EE','NR','PR','R','RR') -- Bug 4422696
113: and pee.element_type_id =
114: (select pet.element_type_id
115: from pay_element_types_f pet,
116: pay_input_values_f piv
117: where abt.input_value_id = piv.input_value_id
118: and piv.element_type_id = pet.element_type_id
119: and p_effective_date between piv.effective_start_date

Line 2306: pay_element_types_f pet,

2302: cursor c_get_accrual_plans (p_assignment_id in number) is
2303: select pap.accrual_plan_id, asg.payroll_id
2304: from pay_element_entries_f pee,
2305: pay_element_links_f pel,
2306: pay_element_types_f pet,
2307: pay_input_values_f piv,
2308: per_all_assignments_f asg,
2309: per_absence_attendance_types abt,
2310: pay_accrual_plans pap