APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_ELEMENT_TYPES_F

Line 438: from pay_element_types_f pet,

434: ,p_include_prj in VARCHAR2) is
435: -- 115.24 Change
436: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
437: select pet.element_type_id
438: from pay_element_types_f pet,
439: pay_element_type_rules per
440: where per.element_set_id = p_element_set_id
441: and per.include_or_exclude = 'I'
442: and per.element_type_id = pet.element_type_id

Line 1705: from pay_element_types_f pet,

1701: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1702:
1703: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
1704: select pet.element_name, pet.element_type_id, pet.reporting_name
1705: from pay_element_types_f pet,
1706: pay_element_type_rules per
1707: where per.element_set_id = p_element_set_id
1708: and per.include_or_exclude = 'I'
1709: and per.element_type_id = pet.element_type_id

Line 1773: pay_element_types_f pet ,

1769: , 'H_HHMM','HOURS'
1770: , NULL) UOM,
1771: pat.absence_category
1772: from
1773: pay_element_types_f pet ,
1774: pay_input_values_f piv,
1775: per_absence_attendance_types pat,
1776: pay_element_type_rules per
1777: where

Line 1862: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;

1858: l_bgp_def BOOLEAN;
1859:
1860: l_ret_bg_id VARCHAR2(2000);
1861:
1862: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1863: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1864:
1865: l_alt_name_change VARCHAR2(1) := 'N';
1866: l_name VARCHAR2(1000);

Line 1863: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;

1859:
1860: l_ret_bg_id VARCHAR2(2000);
1861:
1862: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1863: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1864:
1865: l_alt_name_change VARCHAR2(1) := 'N';
1866: l_name VARCHAR2(1000);
1867: