APPS.PAY_GB_AEI_API dependencies on PER_BUSINESS_GROUPS

Line 49: from per_business_groups pbg

45: l_proc varchar2(72) := g_package||'pay_gb_ins_p45_3';
46: --
47: cursor csr_bg is
48: select legislation_code
49: from per_business_groups pbg
50: where pbg.business_group_id = p_business_group_id;
51: --
52: begin
53: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 153: from per_business_groups pbg

149: l_proc varchar2(72) := g_package||'pay_gb_upd_p45_3';
150: --
151: cursor csr_bg is
152: select legislation_code
153: from per_business_groups pbg
154: where pbg.business_group_id = p_business_group_id;
155: --
156: begin
157: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 238: from per_business_groups pbg

234: l_asg_tax_dist varchar2(50);
235: --
236: cursor csr_bg is
237: select legislation_code
238: from per_business_groups pbg
239: where pbg.business_group_id = p_business_group_id;
240:
241: cursor csr_aggr_paye_flag (c_person_id in number,
242: c_effective_date in date) is

Line 690: from per_business_groups pbg

686: l_asg_tax_dist varchar2(50);
687: --
688: cursor csr_bg is
689: select legislation_code
690: from per_business_groups pbg
691: where pbg.business_group_id = p_business_group_id;
692: --
693:
694: cursor csr_aggr_paye_flag (c_person_id in number,

Line 1396: from per_business_groups pbg

1392: l_person_id number;
1393: --
1394: cursor csr_bg is
1395: select legislation_code
1396: from per_business_groups pbg
1397: where pbg.business_group_id = p_business_group_id;
1398: --
1399:
1400: --

Line 1843: from per_business_groups pbg

1839: l_proc varchar2(72) := g_package||'pay_gb_ins_p46';
1840: --
1841: cursor csr_bg is
1842: select legislation_code
1843: from per_business_groups pbg
1844: where pbg.business_group_id = p_business_group_id;
1845: --
1846: begin
1847: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1927: from per_business_groups pbg

1923: l_proc varchar2(72) := g_package||'pay_gb_upd_p46';
1924: --
1925: cursor csr_bg is
1926: select legislation_code
1927: from per_business_groups pbg
1928: where pbg.business_group_id = p_business_group_id;
1929: --
1930: begin
1931: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2011: from per_business_groups pbg

2007: l_proc varchar2(72) := g_package||'pay_gb_ins_p46_pennot';
2008: --
2009: cursor csr_bg is
2010: select legislation_code
2011: from per_business_groups pbg
2012: where pbg.business_group_id = p_business_group_id;
2013: --
2014: begin
2015: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2108: from per_business_groups pbg

2104: l_proc varchar2(72) := g_package||'pay_gb_upd_p46_pennot';
2105: --
2106: cursor csr_bg is
2107: select legislation_code
2108: from per_business_groups pbg
2109: where pbg.business_group_id = p_business_group_id;
2110: --
2111: begin
2112: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2195: from per_business_groups pbg

2191: l_proc varchar2(72) := g_package||'pay_gb_ins_p46_expat';
2192: --
2193: cursor csr_bg is
2194: select legislation_code
2195: from per_business_groups pbg
2196: where pbg.business_group_id = p_business_group_id;
2197: --
2198: begin
2199: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2277: from per_business_groups pbg

2273: l_proc varchar2(72) := g_package||'pay_gb_upd_p46_expat';
2274: --
2275: cursor csr_bg is
2276: select legislation_code
2277: from per_business_groups pbg
2278: where pbg.business_group_id = p_business_group_id;
2279: --
2280: begin
2281: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2363: from per_business_groups pbg

2359: l_proc varchar2(72) := g_package||'pay_gb_ins_rti_new_strt';
2360: l_legislation_code varchar2(2);
2361: cursor csr_bg is
2362: select legislation_code
2363: from per_business_groups pbg
2364: where pbg.business_group_id = p_business_group_id;
2365: begin
2366: -- hr_utility.trace_on(null, 'GBRTI');
2367: open csr_bg;

Line 2474: from per_business_groups pbg

2470: l_proc varchar2(72) := g_package||'pay_gb_upd_rti_new_strt';
2471: l_legislation_code varchar2(2);
2472: cursor csr_bg is
2473: select legislation_code
2474: from per_business_groups pbg
2475: where pbg.business_group_id = p_business_group_id;
2476: begin
2477: hr_utility.set_location('Entering:'|| l_proc, 300);
2478:

Line 2546: from per_business_groups pbg

2542: l_proc varchar2(72) := g_package||'pay_gb_ins_rti_agg_strt';
2543: l_legislation_code varchar2(2);
2544: cursor csr_bg is
2545: select legislation_code
2546: from per_business_groups pbg
2547: where pbg.business_group_id = p_business_group_id;
2548: begin
2549: -- hr_utility.trace_on(null, 'GBRTI');
2550: open csr_bg;

Line 2615: from per_business_groups pbg

2611: l_proc varchar2(72) := g_package||'pay_gb_upd_rti_agg_strt';
2612: l_legislation_code varchar2(2);
2613: cursor csr_bg is
2614: select legislation_code
2615: from per_business_groups pbg
2616: where pbg.business_group_id = p_business_group_id;
2617: begin
2618: -- hr_utility.trace_on(null, 'GBRTI');
2619: hr_utility.set_location('Entering:'|| l_proc, 300);