APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 133: ,pay_element_types_f petf

129: ,petf.business_group_id
130: ,pivf.name
131: ,peevf.screen_entry_value
132: from pay_element_entries_f peef
133: ,pay_element_types_f petf
134: ,pay_element_entry_values_f peevf
135: ,pay_input_values_f pivf
136: ,pay_status_processing_rules_f psprf
137: ,ff_formulas_f fff

Line 335: ,pay_element_types_f petf

331: select petf.element_name
332: ,petf.business_group_id
333: ,petf.processing_type
334: from pay_element_entries_f peef
335: ,pay_element_types_f petf
336: ,pay_status_processing_rules_f psprf
337: ,ff_formulas_f fff
338: where peef.element_entry_id = c_element_entry_id
339: and petf.element_type_id = peef.element_type_id

Line 467: from pay_element_types_f petf,

463: ,paf.effective_end_date Asgt_End_Date
464: ,pelf.effective_start_date Link_Start_Date
465: ,pelf.effective_end_date Link_End_Date
466: ,pelf.element_link_id Element_Link_Id
467: from pay_element_types_f petf,
468: pay_element_links_f pelf,
469: per_assignments_f paf
470: where petf.element_type_id = c_element_type_id
471: and petf.element_type_id = pelf.element_type_id

Line 706: from pay_element_types_f petf

702: ,c_efective_start_date date) is
703: select petf.element_type_id
704: ,pivf.input_value_id
705: ,pivf.name
706: from pay_element_types_f petf
707: ,pay_input_values_f pivf
708: where petf.element_name like c_element_name || ' for FLSA Calc'
709: and petf.business_group_id = c_business_grp_id
710: and pivf.element_type_id = petf.element_type_id

Line 1307: from pay_element_types_f petf

1303:
1304: cursor c_get_elem_type_id(c_element_name varchar2
1305: ,c_business_group_id number) is
1306: select petf.element_type_id
1307: from pay_element_types_f petf
1308: where petf.element_name = c_element_name
1309: and petf.business_group_id = c_business_group_id;
1310:
1311: -- Cursor to get the Element link details for the assignment

Line 1321: from pay_element_types_f petf,

1317: ,paf.effective_end_date Asgt_End_Date
1318: ,pelf.effective_start_date Link_Start_Date
1319: ,pelf.effective_end_date Link_End_Date
1320: ,pelf.element_link_id Element_Link_Id
1321: from pay_element_types_f petf,
1322: pay_element_links_f pelf,
1323: per_assignments_f paf
1324: where petf.element_type_id = c_element_type_id
1325: and petf.element_type_id = pelf.element_type_id

Line 1430: from pay_element_types_f petf

1426: ,c_inp_val_name varchar2
1427: ,c_business_group_id number) is
1428: select distinct
1429: pivf.input_value_id
1430: from pay_element_types_f petf
1431: ,pay_input_values_f pivf
1432: where petf.element_name = c_element_name
1433: and petf.business_group_id = c_business_group_id
1434: and pivf.element_type_id = petf.element_type_id

Line 1862: from pay_element_types_f petf,

1858: -- Cursor to get Input value id for the Input value 'Daily Amount'
1859: cursor c_get_inp_value_id (c_element_name varchar2
1860: ,c_business_group_id number) is
1861: select pivf.input_value_id
1862: from pay_element_types_f petf,
1863: pay_input_values_f pivf
1864: where petf.element_name = c_element_name || ' for FLSA Calc'
1865: and petf.business_group_id = c_business_group_id
1866: and pivf.element_type_id = petf.element_type_id

Line 2199: from pay_element_types_f petf

2195: ,c_inp_val_name varchar2
2196: ,c_business_group_id number) is
2197: select distinct
2198: pivf.input_value_id
2199: from pay_element_types_f petf
2200: ,pay_input_values_f pivf
2201: where petf.element_name = c_element_name
2202: and petf.business_group_id = c_business_group_id
2203: and pivf.element_type_id = petf.element_type_id