APPS.PAY_IP_UTILITY dependencies on PAY_BALANCE_DIMENSIONS

Line 1332: FROM pay_balance_dimensions

1328:
1329: CURSOR get_balance_dimension_csr IS
1330: SELECT balance_dimension_id,
1331: dimension_name
1332: FROM pay_balance_dimensions
1333: WHERE legislation_code = 'ZZ';
1334:
1335: BEGIN
1336: hr_utility.set_location('pay_ip_utility.ins_bal_dim_ownership',10);

Line 1358: ,pay_balance_dimensions pbd

1354: CURSOR get_defined_balance_csr IS
1355: SELECT pdb.defined_balance_id,
1356: replace(upper(pbt.balance_name),' ','_') || pbd.database_item_suffix def_bal_name
1357: FROM pay_defined_balances pdb
1358: ,pay_balance_dimensions pbd
1359: ,pay_balance_types pbt
1360: WHERE pdb.legislation_code = 'ZZ'
1361: AND pdb.balance_type_id = pbt.balance_type_id
1362: AND pdb.legislation_code = pbt.legislation_code

Line 1389: ,pay_balance_dimensions pbd

1385: CURSOR get_route_csr IS
1386: SELECT route.route_id,
1387: route.route_name
1388: FROM ff_routes route
1389: ,pay_balance_dimensions pbd
1390: WHERE pbd.legislation_code = 'ZZ'
1391: AND pbd.route_id = route.route_id
1392: UNION
1393: SELECT route.route_id,

Line 1396: ,pay_balance_dimensions pbd,

1392: UNION
1393: SELECT route.route_id,
1394: route.route_name
1395: FROM ff_routes route
1396: ,pay_balance_dimensions pbd,
1397: pay_dimension_routes pdr
1398: WHERE pbd.legislation_code = 'ZZ'
1399: AND pbd.balance_dimension_id = pdr.balance_dimension_id
1400: AND pdr.route_id = route.route_id;