APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_TYPES_F

Line 149: ,pay_element_types_f petf

145: ,petf.business_group_id
146: ,pivf.name
147: ,peevf.screen_entry_value
148: from pay_element_entries_f peef
149: ,pay_element_types_f petf
150: ,pay_element_entry_values_f peevf
151: ,pay_input_values_f pivf
152: ,pay_status_processing_rules_f psprf
153: ,ff_formulas_f fff

Line 351: ,pay_element_types_f petf

347: select petf.element_name
348: ,petf.business_group_id
349: ,petf.processing_type
350: from pay_element_entries_f peef
351: ,pay_element_types_f petf
352: ,pay_status_processing_rules_f psprf
353: ,ff_formulas_f fff
354: where peef.element_entry_id = c_element_entry_id
355: and petf.element_type_id = peef.element_type_id

Line 483: from pay_element_types_f petf,

479: ,paf.effective_end_date Asgt_End_Date
480: ,pelf.effective_start_date Link_Start_Date
481: ,pelf.effective_end_date Link_End_Date
482: ,pelf.element_link_id Element_Link_Id
483: from pay_element_types_f petf,
484: pay_element_links_f pelf,
485: per_assignments_f paf
486: where petf.element_type_id = c_element_type_id
487: and petf.element_type_id = pelf.element_type_id

Line 734: from pay_element_types_f petf

730: ,c_efective_start_date date) is
731: select petf.element_type_id
732: ,pivf.input_value_id
733: ,pivf.name
734: from pay_element_types_f petf
735: ,pay_input_values_f pivf
736: where petf.element_name like c_element_name || ' for FLSA Calc'
737: and petf.business_group_id = c_business_grp_id
738: and pivf.element_type_id = petf.element_type_id

Line 1393: from pay_element_types_f petf

1389:
1390: cursor c_get_elem_type_id(c_element_name varchar2
1391: ,c_business_group_id number) is
1392: select petf.element_type_id
1393: from pay_element_types_f petf
1394: where petf.element_name = c_element_name
1395: and petf.business_group_id = c_business_group_id;
1396:
1397: -- Cursor to get the Element link details for the assignment

Line 1407: from pay_element_types_f petf,

1403: ,paf.effective_end_date Asgt_End_Date
1404: ,pelf.effective_start_date Link_Start_Date
1405: ,pelf.effective_end_date Link_End_Date
1406: ,pelf.element_link_id Element_Link_Id
1407: from pay_element_types_f petf,
1408: pay_element_links_f pelf,
1409: per_assignments_f paf
1410: where petf.element_type_id = c_element_type_id
1411: and petf.element_type_id = pelf.element_type_id

Line 1528: from pay_element_types_f petf

1524: ,c_inp_val_name varchar2
1525: ,c_business_group_id number) is
1526: select distinct
1527: pivf.input_value_id
1528: from pay_element_types_f petf
1529: ,pay_input_values_f pivf
1530: where petf.element_name = c_element_name
1531: and petf.business_group_id = c_business_group_id
1532: and pivf.element_type_id = petf.element_type_id

Line 1960: from pay_element_types_f petf,

1956: -- Cursor to get Input value id for the Input value 'Daily Amount'
1957: cursor c_get_inp_value_id (c_element_name varchar2
1958: ,c_business_group_id number) is
1959: select pivf.input_value_id
1960: from pay_element_types_f petf,
1961: pay_input_values_f pivf
1962: where petf.element_name = c_element_name || ' for FLSA Calc'
1963: and petf.business_group_id = c_business_group_id
1964: and pivf.element_type_id = petf.element_type_id

Line 2297: from pay_element_types_f petf

2293: ,c_inp_val_name varchar2
2294: ,c_business_group_id number) is
2295: select distinct
2296: pivf.input_value_id
2297: from pay_element_types_f petf
2298: ,pay_input_values_f pivf
2299: where petf.element_name = c_element_name
2300: and petf.business_group_id = c_business_group_id
2301: and pivf.element_type_id = petf.element_type_id