APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_DEFINED_BALANCES

Line 891: from pay_defined_balances

887: balance_type_id
888: bulk collect
889: into l_defined_balance_ids,
890: l_balance_type_ids
891: from pay_defined_balances
892: where balance_dimension_id = p_balance_dimension_id;
893: --
894: for i in 1..l_defined_balance_ids.count loop
895: --

Line 1019: pay_defined_balances def

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
1022: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null