DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 114: from pay_element_types_f pet,

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

Line 1964: pay_element_types_f pet,

1960: cursor c_get_accrual_plans (p_assignment_id in number) is
1961: select pap.accrual_plan_id, asg.payroll_id
1962: from pay_element_entries_f pee,
1963: pay_element_links_f pel,
1964: pay_element_types_f pet,
1965: pay_input_values_f piv,
1966: per_all_assignments_f asg,
1967: per_absence_attendance_types abt,
1968: pay_accrual_plans pap