APPS.PAY_BCT_BUS dependencies on PER_BUSINESS_GROUPS

Line 27: -- pay_batch_control_totals and PER_BUSINESS_GROUPS

23: --
24: -- Declare cursor
25: --
26: -- In the following cursor statement add join(s) between
27: -- pay_batch_control_totals and PER_BUSINESS_GROUPS
28: -- so that the security_group_id for
29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is

Line 33: from per_business_groups pbg

29: -- the current business group context can be derived.
30: -- Remove this comment when the edit has been completed.
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , pay_batch_control_totals bct
35: , pay_batch_headers bth
36: where bct.batch_control_id = p_batch_control_id
37: and bth.batch_id = bct.batch_id

Line 94: -- pay_batch_control_totals and PER_BUSINESS_GROUPS

90: --
91: -- Declare cursor
92: --
93: -- In the following cursor statement add join(s) between
94: -- pay_batch_control_totals and PER_BUSINESS_GROUPS
95: -- so that the legislation_code for
96: -- the current business group context can be derived.
97: -- Remove this comment when the edit has been completed.
98: cursor csr_leg_code is

Line 100: from per_business_groups pbg

96: -- the current business group context can be derived.
97: -- Remove this comment when the edit has been completed.
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups pbg
101: , pay_batch_control_totals bct
102: , pay_batch_headers bth
103: where bct.batch_control_id = p_batch_control_id
104: and bth.batch_id = bct.batch_id

Line 581: from PER_BUSINESS_GROUPS perbg,

577: l_control_total_dup := p_control_total ;
578:
579: -- gets currency_code
580: select CURRENCY_CODE into l_curr_code
581: from PER_BUSINESS_GROUPS perbg,
582: pay_batch_headers pybeeh
583: where perbg.BUSINESS_GROUP_ID = pybeeh.BUSINESS_GROUP_ID and
584: pybeeh.batch_id = p_batch_id;
585: --