DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ADHOC dependencies on PAY_ELEMENT_TYPES_F

Line 144: ,pay_element_types_f petf

140: ,v_element_type_id IN number) IS
141: SELECT DISTINCT
142: petf.element_type_id
143: FROM pay_element_type_rules petr
144: ,pay_element_types_f petf
145: WHERE (
146: petr.element_set_id = v_element_set_id
147: AND petr.element_type_id = petf.element_type_id
148: )

Line 164: FROM pay_element_types_f petf

160: AND parent_classification_id IN
161: (
162: SELECT DISTINCT
163: petf.classification_id
164: FROM pay_element_types_f petf
165: WHERE (
166: petf.element_type_id = v_element_type_id
167: )
168: );

Line 214: FROM pay_element_types_f

210: SELECT min (effective_start_date)
211: ,min (business_group_id)
212: INTO l_effective_start_date
213: ,l_business_group_id
214: FROM pay_element_types_f
215: WHERE element_type_id = proc_element_type_id;
216:
217: OPEN csr_get_class_id (proc_element_type_id);
218: