APPS.PAY_PEL_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups pbg

26: -- Declare cursor
27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , pay_element_links_f pel
32: where pel.element_link_id = p_element_link_id
33: and pbg.business_group_id = pel.business_group_id;
34: --

Line 37: l_security_group_id per_business_groups.SECURITY_GROUP_ID%TYPE;

33: and pbg.business_group_id = pel.business_group_id;
34: --
35: -- Declare local variables
36: --
37: l_security_group_id per_business_groups.SECURITY_GROUP_ID%TYPE;
38: l_proc varchar2(72) := g_package||'set_security_group_id';
39: --
40: begin
41: --

Line 94: from per_business_groups pbg

90: -- Declare cursor
91: --
92: cursor csr_leg_code is
93: select pbg.legislation_code
94: from per_business_groups pbg
95: , pay_element_links_f pel
96: where pel.element_link_id = p_element_link_id
97: and pbg.business_group_id = pel.business_group_id;
98: --

Line 101: l_legislation_code per_business_groups.LEGISLATION_CODE%TYPE;

97: and pbg.business_group_id = pel.business_group_id;
98: --
99: -- Declare local variables
100: --
101: l_legislation_code per_business_groups.LEGISLATION_CODE%TYPE;
102: l_proc varchar2(72) := g_package||'return_legislation_code';
103: --
104: Begin
105: --

Line 1324: l_leg_code per_business_groups.legislation_code%TYPE;

1320: l_proc varchar2(72) := g_package || 'chk_costable_type';
1321: l_costable_flag pay_element_classifications.costable_flag%TYPE;
1322: l_uom pay_input_values_f.UOM%TYPE;
1323:
1324: l_leg_code per_business_groups.legislation_code%TYPE;
1325: l_costing_dc pay_element_classifications.costing_debit_or_credit%TYPE;
1326:
1327: l_dummy pay_element_sets.element_set_id%TYPE;
1328:

Line 1348: per_business_groups pbg

1344:
1345: cursor csr_legcode_cr_db_type is
1346: select distinct pec.costing_debit_or_credit, pbg.legislation_code
1347: from pay_element_classifications pec, pay_element_types_f pet,
1348: per_business_groups pbg
1349: where pec.classification_id = pet.classification_id
1350: and pet.business_group_id = pbg.business_group_id (+)
1351: and pet.element_type_id = p_element_type_id;
1352: