APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 1017: from per_business_groups_perf bg,

1013: --
1014: cursor csr_def is
1015: select def.defined_balance_id,
1016: def.business_group_id
1017: from per_business_groups_perf bg,
1018: pay_balance_dimensions dim,
1019: pay_defined_balances def
1020: where bg.legislation_code = 'JP'
1021: and dim.business_group_id = bg.business_group_id

Line 1031: from per_business_groups_perf bg,

1027: --
1028: cursor csr_dim is
1029: select dim.balance_dimension_id,
1030: dim.description
1031: from per_business_groups_perf bg,
1032: pay_balance_dimensions dim
1033: where bg.legislation_code = 'JP'
1034: and dim.business_group_id = bg.business_group_id
1035: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

Line 1049: from per_business_groups_perf bg,

1045: --
1046: select upper(dim.expiry_checking_code) expiry_checking_code,
1047: upper(dim.start_date_code) start_date_code,
1048: min(dim.description) description
1049: from per_business_groups_perf bg,
1050: pay_balance_dimensions dim
1051: where bg.legislation_code = 'JP'
1052: and dim.business_group_id = bg.business_group_id
1053: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)