APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on PAY_ELEMENT_TYPES_F

Line 359: from pay_element_types_f pet,

355: ,p_include_prj in VARCHAR2) is
356: -- 115.24 Change
357: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
358: select pet.element_type_id
359: from pay_element_types_f pet,
360: pay_element_type_rules per
361: where per.element_set_id = p_element_set_id
362: and per.include_or_exclude = 'I'
363: and per.element_type_id = pet.element_type_id

Line 1478: from pay_element_types_f pet,

1474: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1475:
1476: cursor c_elements(p_element_set_id in number, p_effective_date in date) is
1477: select pet.element_name, pet.element_type_id, pet.reporting_name
1478: from pay_element_types_f pet,
1479: pay_element_type_rules per
1480: where per.element_set_id = p_element_set_id
1481: and per.include_or_exclude = 'I'
1482: and per.element_type_id = pet.element_type_id

Line 1582: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;

1578: l_bgp_def BOOLEAN;
1579:
1580: l_ret_bg_id VARCHAR2(2000);
1581:
1582: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1583: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1584:
1585: l_alt_name_change VARCHAR2(1) := 'N';
1586: l_name VARCHAR2(1000);

Line 1583: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;

1579:
1580: l_ret_bg_id VARCHAR2(2000);
1581:
1582: l_new_en_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1583: l_new_dis_repname PAY_ELEMENT_TYPES_F.REPORTING_NAME%TYPE;
1584:
1585: l_alt_name_change VARCHAR2(1) := 'N';
1586: l_name VARCHAR2(1000);
1587: