APPS.PAY_PURGE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1155: l_et_id pay_element_types_f.element_type_id%type;

1151: -- is created.
1152: c_iv_limit constant number := 15; -- which includes Jurdisdiction.
1153:
1154: l_iv_count number;
1155: l_et_id pay_element_types_f.element_type_id%type;
1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;

Line 1158: l_et_name pay_element_types_f.element_name%type;

1154: l_iv_count number;
1155: l_et_id pay_element_types_f.element_type_id%type;
1156: l_iv_id pay_input_values_f.input_value_id%type;
1157: l_el_id pay_element_links_f.element_link_id%type;
1158: l_et_name pay_element_types_f.element_name%type;
1159: l_iv_name pay_input_values_f.name%type;
1160: l_bg_name per_business_groups.name%type;
1161: l_et_count number := 0;
1162:

Line 1243: l_et_name pay_element_types_f.element_name%type;

1239: p_bg_name in varchar2,
1240: p_bg_id in number,
1241: p_et_count in number
1242: ) return number is
1243: l_et_name pay_element_types_f.element_name%type;
1244: l_et_id pay_element_types_f.element_type_id%type;
1245: l_el_id pay_element_links_f.element_link_id%type;
1246: l_ptr hr_lookups.meaning%type;
1247: begin

Line 1244: l_et_id pay_element_types_f.element_type_id%type;

1240: p_bg_id in number,
1241: p_et_count in number
1242: ) return number is
1243: l_et_name pay_element_types_f.element_name%type;
1244: l_et_id pay_element_types_f.element_type_id%type;
1245: l_el_id pay_element_links_f.element_link_id%type;
1246: l_ptr hr_lookups.meaning%type;
1247: begin
1248:

Line 1285: update pay_element_types_f pet

1281:
1282: -- The element_information1 needs to be set to 'B'
1283: -- to allow rollup of subject balances. We have
1284: -- no 'official' way and so so use direct update.
1285: update pay_element_types_f pet
1286: set pet.element_information1 = 'B'
1287: where pet.element_type_id = l_et_id;
1288:
1289: -- We need to create an appropriate element link

Line 1314: l_et_name pay_element_types_f.element_name%type;

1310: p_iv_uom in varchar2,
1311: p_seq in number,
1312: p_bt_id in number default null
1313: ) return number is
1314: l_et_name pay_element_types_f.element_name%type;
1315: l_bg_id per_business_groups.business_group_id%type;
1316: l_et_id pay_element_types_f.element_type_id%type;
1317:
1318: begin

Line 1316: l_et_id pay_element_types_f.element_type_id%type;

1312: p_bt_id in number default null
1313: ) return number is
1314: l_et_name pay_element_types_f.element_name%type;
1315: l_bg_id per_business_groups.business_group_id%type;
1316: l_et_id pay_element_types_f.element_type_id%type;
1317:
1318: begin
1319:
1320: hr_utility.set_location ('cre_iv_bf', 10);

Line 1330: pay_element_types_f pet

1326: into l_et_name,
1327: l_et_id,
1328: l_bg_id
1329: from pay_element_links_f pel,
1330: pay_element_types_f pet
1331: where pel.element_link_id = p_el_id
1332: and pel.effective_start_date = c_sot
1333: and pel.effective_end_date = c_eot
1334: and pet.element_type_id = pel.element_type_id

Line 1421: pay_element_types_f pet,

1417: select 1
1418: into l_dummy
1419: from pay_balance_feeds_f pbf,
1420: pay_input_values_f piv,
1421: pay_element_types_f pet,
1422: pay_element_classifications pec
1423: where pbf.balance_type_id = c1rec.balance_type_id
1424: and piv.input_value_id = pbf.input_value_id
1425: and pet.element_type_id = piv.element_type_id