APPS.PAY_PURGE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 915: l_period_type pay_balance_dimensions.period_type%type;

911: ) is
912: l_new_assactid number;
913: l_new_payactid number;
914: l_asgact_rec t_asgact_rec; -- assignment action info.
915: l_period_type pay_balance_dimensions.period_type%type;
916: l_creating_new_action boolean;
917: --
918: -- Cursor to check the period type
919: --

Line 926: ,pay_balance_dimensions pbd

922: select
923: pbd.period_type
924: from
925: pay_defined_balances pdb
926: ,pay_balance_dimensions pbd
927: where
928: pdb.defined_balance_id = p_defined_balance_id
929: and pbd.balance_dimension_id = pdb.balance_dimension_id
930: ;

Line 1124: pay_balance_dimensions pbd,

1120: select upper(replace(pbt.balance_name, ' ', '_')) ||
1121: pbd.database_item_suffix
1122: into l_balance_name
1123: from pay_balance_types pbt,
1124: pay_balance_dimensions pbd,
1125: pay_defined_balances pdb
1126: where pdb.defined_balance_id = c1rec.defined_balance_id
1127: and pbt.balance_type_id = pdb.balance_type_id
1128: and pbd.balance_dimension_id = pdb.balance_dimension_id;

Line 1187: pay_balance_dimensions pbd

1183: nvl(pbt.jurisdiction_level, 0) jurisdiction_level
1184: from pay_balance_set_members bsm,
1185: pay_defined_balances pdb,
1186: pay_balance_types pbt,
1187: pay_balance_dimensions pbd
1188: where bsm.balance_set_id = p_balance_set_id
1189: and pdb.defined_balance_id = bsm.defined_balance_id
1190: and pbt.balance_type_id = pdb.balance_type_id
1191: and pbd.balance_dimension_id = pdb.balance_dimension_id

Line 1206: pay_balance_dimensions pbd

1202: ff_database_items fdi,
1203: ff_user_entities fue,
1204: pay_defined_balances pdb,
1205: pay_balance_types pbt,
1206: pay_balance_dimensions pbd
1207: where ((fff.business_group_id is null and fff.legislation_code is null)
1208: or (fff.business_group_id is null
1209: and fff.legislation_code = p_legislation_code)
1210: or (fff.legislation_code is null