DBA Data[Home] [Help]

APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 1275: pay_balance_dimensions d,

1271: and assignment_id is null
1272: and process_group_id is null
1273: and defined_balance_id in (
1274: select db.defined_balance_id from
1275: pay_balance_dimensions d,
1276: pay_defined_balances db
1277: where d.balance_dimension_id = db.balance_dimension_id
1278: and d.dimension_type = 'O'
1279: and d.dimension_level = 'PG');

Line 1287: select db.defined_balance_id from pay_balance_dimensions d, pay_defined_balances db

1283: where assignment_id is null
1284: and person_id = p_person_id
1285: and process_group_id is null
1286: and defined_balance_id in (
1287: select db.defined_balance_id from pay_balance_dimensions d, pay_defined_balances db
1288: where d.balance_dimension_id = db.balance_dimension_id
1289: and d.dimension_type = 'O'
1290: and d.dimension_level = 'PG');
1291: