DBA Data[Home] [Help]

APPS.PAY_PBC_BUS dependencies on PAY_BALANCE_CATEGORIES_F

Line 30: , pay_balance_categories_f pbc

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pay_balance_categories_f pbc
31: where pbc.balance_category_id = p_balance_category_id
32: and pbg.business_group_id = pbc.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pay_balance_categories_f pbc

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pay_balance_categories_f pbc
95: where pbc.balance_category_id = p_balance_category_id
96: and pbg.business_group_id (+) = pbc.business_group_id;
97: --
98: -- Declare local variables

Line 210: from pay_balance_categories_f pbc

206: cursor csr_category_name is
207: select pbc.category_name
208: , pbc.legislation_code
209: , pbc.business_group_id
210: from pay_balance_categories_f pbc
211: where pbc.category_name = p_category_name;
212: Begin
213: --
214: hr_utility.set_location('Entering: '||l_proc,5);

Line 343: from pay_balance_categories_f pbc

339: cursor csr_user_category_name is
340: select pbc.user_category_name
341: , pbc.legislation_code
342: , pbc.business_group_id
343: from pay_balance_categories_f pbc
344: where pbc.user_category_name = p_user_category_name;
345: Begin
346: --
347: hr_utility.set_location('Entering: '||l_proc,5);

Line 1072: -- NOTE: USER rows are not permitted in PAY_BALANCE_CATEGORIES_F

1068: --
1069: BEGIN
1070: --
1071: -- Call the supporting procedure to check startup mode
1072: -- NOTE: USER rows are not permitted in PAY_BALANCE_CATEGORIES_F
1073: --
1074: IF (p_insert) THEN
1075: hr_startup_data_api_support.chk_startup_action
1076: (p_generic_allowed => TRUE