APPS.PAY_EEI_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 30: , pay_element_types_f pet

26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_element_type_extra_info eei
30: , pay_element_types_f pet
31: where eei.element_type_extra_info_id = p_element_type_extra_info_id
32: and pbg.business_group_id = pet.business_group_id
33: and pet.element_type_id = eei.element_type_id;
34:

Line 93: , pay_element_types_f pet

89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_business_groups pbg
92: , pay_element_type_extra_info eei
93: , pay_element_types_f pet
94: where eei.element_type_extra_info_id = p_element_type_extra_info_id
95: and pbg.business_group_id = pet.business_group_id
96: and pet.element_type_id = eei.element_type_id;
97: --

Line 596: from pay_element_types_f pet

592: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id);
593:
594: cursor c_get_bus_grp_id is
595: select business_group_id
596: from pay_element_types_f pet
597: where pet.element_type_id = p_element_type_id ;
598:
599: -- Add Cursors to check the entered Rate type and element Name.
600:

Line 603: FROM PAY_ELEMENT_TYPES_F pet

599: -- Add Cursors to check the entered Rate type and element Name.
600:
601: CURSOR c_element_name IS
602: SELECT 'Y'
603: FROM PAY_ELEMENT_TYPES_F pet
604: WHERE UPPER(pet.element_name) = UPPER(p_qualifier)
605: AND (( pet.business_group_id is not null
606: and pet.business_group_id = nvl(l_business_group_id,
607: pet.business_group_id))

Line 1046: from pay_element_type_extra_info petei,pay_element_types_f pet

1042:
1043:
1044: cursor c_duplicate is
1045: select 1
1046: from pay_element_type_extra_info petei,pay_element_types_f pet
1047: where petei.element_type_id <> p_element_type_id
1048: and information_type = p_information_type
1049: and upper(eei_information2) = upper(p_element_code)
1050: and petei.element_type_id not in ((select element_type_id

Line 1051: from pay_element_types_f

1047: where petei.element_type_id <> p_element_type_id
1048: and information_type = p_information_type
1049: and upper(eei_information2) = upper(p_element_code)
1050: and petei.element_type_id not in ((select element_type_id
1051: from pay_element_types_f
1052: where retro_summ_ele_id = p_element_type_id)
1053: union
1054: (select retro_summ_ele_id
1055: from pay_element_types_f

Line 1055: from pay_element_types_f

1051: from pay_element_types_f
1052: where retro_summ_ele_id = p_element_type_id)
1053: union
1054: (select retro_summ_ele_id
1055: from pay_element_types_f
1056: where element_type_id = p_element_type_id
1057: and retro_summ_ele_id IS NOT NULL ))
1058: and pet.element_type_id=petei.element_type_id
1059: and rownum =1;

Line 1064: from pay_element_type_extra_info petei,pay_element_types_f pet

1060:
1061:
1062: cursor c_duplicate_advanced_retro is
1063: select 1
1064: from pay_element_type_extra_info petei,pay_element_types_f pet
1065: where petei.element_type_id <> p_element_type_id
1066: and information_type = p_information_type
1067: and upper(eei_information2) = upper(p_element_code)
1068: and petei.element_type_id not in ((select prcu.creator_id

Line 1086: from pay_element_types_f

1082:
1083: /*
1084: cursor c_is_retro_ele is
1085: select 1
1086: from pay_element_types_f
1087: where retro_summ_ele_id = p_element_type_id;
1088: */
1089:
1090: cursor c_element_code_exists

Line 1207: FROM pay_element_types_f pet

1203:
1204: CURSOR is_ele_spread_bonus
1205: IS
1206: SELECT 1
1207: FROM pay_element_types_f pet
1208: ,pay_input_values_f piv
1209: WHERE piv.element_type_id = pet.element_type_id
1210: AND pet.element_type_id = p_element_type_id
1211: AND (pet.processing_type = 'N'

Line 1249: l_element_name pay_element_types_f.element_name%TYPE;

1245:
1246: --
1247: l_proc varchar2(72) := g_package||'chk_valid_bonus_elements';
1248:
1249: l_element_name pay_element_types_f.element_name%TYPE;
1250: l_processing_type pay_element_types_f.processing_type%TYPE;
1251: l_uom pay_input_values_f.uom%TYPE;
1252:
1253: CURSOR csr_get_element_info

Line 1250: l_processing_type pay_element_types_f.processing_type%TYPE;

1246: --
1247: l_proc varchar2(72) := g_package||'chk_valid_bonus_elements';
1248:
1249: l_element_name pay_element_types_f.element_name%TYPE;
1250: l_processing_type pay_element_types_f.processing_type%TYPE;
1251: l_uom pay_input_values_f.uom%TYPE;
1252:
1253: CURSOR csr_get_element_info
1254: IS

Line 1258: FROM pay_element_types_f pet,

1254: IS
1255: SELECT pet.element_name
1256: ,pet.processing_type
1257: ,piv.uom
1258: FROM pay_element_types_f pet,
1259: pay_input_values_f piv
1260: WHERE pet.element_type_id = p_element_type_id
1261: AND pet.element_type_id = piv.element_type_id (+)
1262: AND upper(piv.NAME (+)) = 'CLAIM DATE';

Line 1300: from pay_element_types_f

1296: --
1297: cursor row_type(p_element_type_id number)
1298: is
1299: select business_group_id
1300: from pay_element_types_f
1301: where element_type_id = p_element_type_id
1302: and business_group_id is not null
1303: and rownum = 1;
1304: --

Line 1305: l_bg pay_element_types_f.business_group_id%type;

1301: where element_type_id = p_element_type_id
1302: and business_group_id is not null
1303: and rownum = 1;
1304: --
1305: l_bg pay_element_types_f.business_group_id%type;
1306: l_proc varchar2(72) := g_package||'insert_validate';
1307: --
1308: Begin
1309: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1429: from pay_element_types_f

1425: --
1426: cursor row_type(p_element_type_id number)
1427: is
1428: select business_group_id
1429: from pay_element_types_f
1430: where element_type_id = p_element_type_id
1431: and business_group_id is not null
1432: and rownum = 1;
1433: --

Line 1434: l_bg pay_element_types_f.business_group_id%type;

1430: where element_type_id = p_element_type_id
1431: and business_group_id is not null
1432: and rownum = 1;
1433: --
1434: l_bg pay_element_types_f.business_group_id%type;
1435: l_proc varchar2(72) := g_package||'update_validate';
1436: --
1437: Begin
1438: hr_utility.set_location('Entering:'||l_proc, 5);