APPS.PAY_HK_IR56 dependencies on PAY_ELEMENT_TYPES_F

Line 86: l_processing_type pay_element_types_f.processing_type%TYPE;

82: l_start_date DATE;
83: l_end_date DATE;
84: l_fin_start_date DATE;
85: l_fin_end_date DATE;
86: l_processing_type pay_element_types_f.processing_type%TYPE;
87: l_particulars hr_lookups.description%TYPE;
88: l_hire_date per_periods_of_service.date_start%TYPE;
89: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
90: i NUMBER := 1;

Line 102: FROM pay_element_types_f pet,

98: IS
99: SELECT min(pee.effective_start_date),
100: max(pee.effective_end_date),
101: min(pet.processing_type)
102: FROM pay_element_types_f pet,
103: pay_element_entries_f pee,
104: pay_element_links_f pel,
105: pay_balance_types pbt,
106: pay_balance_feeds_f pbf,

Line 151: pay_element_types_f pet,

147: p_fin_end_date date)
148: IS
149: SELECT COUNT(pivf.input_value_id)
150: FROM pay_element_entries_f pee,
151: pay_element_types_f pet,
152: pay_input_values_f pivf,
153: pay_balance_types pbt,
154: pay_balance_feeds_f pbf
155: WHERE pee.assignment_id = p_assignment_id