APPS.PAY_EEI_MIG_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 981: from pay_element_types_f

977: --
978: cursor row_type(p_element_type_id number)
979: is
980: select business_group_id
981: from pay_element_types_f
982: where element_type_id = p_element_type_id
983: and business_group_id is not null
984: and rownum = 1;
985: --

Line 986: l_bg pay_element_types_f.business_group_id%type;

982: where element_type_id = p_element_type_id
983: and business_group_id is not null
984: and rownum = 1;
985: --
986: l_bg pay_element_types_f.business_group_id%type;
987: l_proc varchar2(72) := g_package||'insert_validate';
988: --
989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1074: from pay_element_types_f

1070: --
1071: cursor row_type(p_element_type_id number)
1072: is
1073: select business_group_id
1074: from pay_element_types_f
1075: where element_type_id = p_element_type_id
1076: and business_group_id is not null
1077: and rownum = 1;
1078: --

Line 1079: l_bg pay_element_types_f.business_group_id%type;

1075: where element_type_id = p_element_type_id
1076: and business_group_id is not null
1077: and rownum = 1;
1078: --
1079: l_bg pay_element_types_f.business_group_id%type;
1080: l_proc varchar2(72) := g_package||'update_validate';
1081: --
1082: Begin
1083: hr_utility.set_location('Entering:'||l_proc, 5);