APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 1035: from per_business_groups_perf bg,

1031: --
1032: cursor csr_def is
1033: select def.defined_balance_id,
1034: def.business_group_id
1035: from per_business_groups_perf bg,
1036: pay_balance_dimensions dim,
1037: pay_defined_balances def
1038: where bg.legislation_code = 'JP'
1039: and dim.business_group_id = bg.business_group_id

Line 1049: from per_business_groups_perf bg,

1045: --
1046: cursor csr_dim is
1047: select dim.balance_dimension_id,
1048: dim.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 pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

Line 1067: from per_business_groups_perf bg,

1063: --
1064: select upper(dim.expiry_checking_code) expiry_checking_code,
1065: upper(dim.start_date_code) start_date_code,
1066: min(dim.description) description
1067: from per_business_groups_perf bg,
1068: pay_balance_dimensions dim
1069: where bg.legislation_code = 'JP'
1070: and dim.business_group_id = bg.business_group_id
1071: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)