DBA Data[Home] [Help]

APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_DEFINED_BALANCES

Line 900: from pay_defined_balances

896: balance_type_id
897: bulk collect
898: into l_defined_balance_ids,
899: l_balance_type_ids
900: from pay_defined_balances
901: where balance_dimension_id = p_balance_dimension_id;
902: --
903: for i in 1..l_defined_balance_ids.count loop
904: --

Line 1037: pay_defined_balances def

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