DBA Data[Home] [Help]

APPS.PAY_TXR_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 42: -- pay_taxability_rules and PER_BUSINESS_GROUPS_PERF

38: --
39: -- Declare cursor
40: --
41: -- EDIT_HERE In the following cursor statement add join(s) between
42: -- pay_taxability_rules and PER_BUSINESS_GROUPS_PERF
43: -- so that the security_group_id for
44: -- the current business group context can be derived.
45: -- Remove this comment when the edit has been completed.
46: cursor csr_sec_grp is

Line 49: from per_business_groups_perf pbg

45: -- Remove this comment when the edit has been completed.
46: cursor csr_sec_grp is
47: select pbg.security_group_id,
48: pbg.legislation_code
49: from per_business_groups_perf pbg
50: , pay_taxability_rules txr
51: -- , EDIT_HERE table_name(s) 333
52: where txr.jurisdiction_code = p_jurisdiction_code
53: and nvl(txr.tax_type, 'X') = nvl(p_tax_type, 'X')

Line 160: -- pay_taxability_rules and PER_BUSINESS_GROUPS_PERF

156: --
157: -- Declare cursor
158: --
159: -- EDIT_HERE In the following cursor statement add join(s) between
160: -- pay_taxability_rules and PER_BUSINESS_GROUPS_PERF
161: -- so that the legislation_code for
162: -- the current business group context can be derived.
163: -- Remove this comment when the edit has been completed.
164: cursor csr_leg_code is

Line 166: from per_business_groups_perf pbg

162: -- the current business group context can be derived.
163: -- Remove this comment when the edit has been completed.
164: cursor csr_leg_code is
165: select pbg.legislation_code
166: from per_business_groups_perf pbg
167: , pay_taxability_rules txr
168: -- , EDIT_HERE table_name(s) 333
169: where txr.jurisdiction_code = p_jurisdiction_code
170: and nvl(txr.tax_type, 'X') = nvl(p_tax_type, 'X')