APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_BALANCE_DIMENSIONS

Line 134: pay_balance_dimensions d

130: IS
131: SELECT defined_balance_id
132: FROM pay_defined_balances db,
133: pay_balance_types b,
134: pay_balance_dimensions d
135: WHERE b.balance_name = p_balance_name
136: AND d.dimension_name = p_dimension_name
137: AND db.balance_type_id = b.balance_type_id
138: AND db.balance_dimension_id = d.balance_dimension_id;

Line 543: pay_balance_dimensions d

539: IS
540: SELECT defined_balance_id
541: FROM pay_defined_balances db,
542: pay_balance_types b,
543: pay_balance_dimensions d
544: WHERE b.balance_name = p_balance_name
545: AND d.dimension_name = p_dimension_name
546: AND db.balance_type_id = b.balance_type_id
547: AND db.balance_dimension_id = d.balance_dimension_id;

Line 1024: pay_balance_dimensions pbd,

1020: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1021: IS
1022: SELECT pdb.defined_balance_id
1023: FROM pay_defined_balances pdb,
1024: pay_balance_dimensions pbd,
1025: pay_balance_types pbt
1026: WHERE pbt.balance_name = c_balance_name
1027: AND pbd.database_item_suffix = c_dim_name
1028: AND pbt.balance_type_id = pdb.balance_type_id

Line 1355: pay_balance_dimensions pbd,

1351: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1352: IS
1353: SELECT pdb.defined_balance_id
1354: FROM pay_defined_balances pdb,
1355: pay_balance_dimensions pbd,
1356: pay_balance_types pbt
1357: WHERE pbt.balance_name = c_balance_name
1358: AND pbd.database_item_suffix = c_dim_name
1359: AND pbt.balance_type_id = pdb.balance_type_id

Line 1693: pay_balance_dimensions pbd,

1689: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
1690: IS
1691: SELECT pdb.defined_balance_id
1692: FROM pay_defined_balances pdb,
1693: pay_balance_dimensions pbd,
1694: pay_balance_types pbt
1695: WHERE pbt.balance_name = c_balance_name
1696: AND pbd.database_item_suffix = c_dim_name
1697: AND pbt.balance_type_id = pdb.balance_type_id

Line 2363: pay_balance_dimensions pbd,

2359: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2360: IS
2361: SELECT pdb.defined_balance_id
2362: FROM pay_defined_balances pdb,
2363: pay_balance_dimensions pbd,
2364: pay_balance_types pbt
2365: WHERE pbt.balance_name = c_balance_name
2366: AND pbd.database_item_suffix = c_dim_name
2367: AND pbt.balance_type_id = pdb.balance_type_id

Line 2648: pay_balance_dimensions pbd,

2644: CURSOR csr_get_taxable_pay(c_balance_name VARCHAR2, c_dim_name VARCHAR2)
2645: IS
2646: SELECT pdb.defined_balance_id
2647: FROM pay_defined_balances pdb,
2648: pay_balance_dimensions pbd,
2649: pay_balance_types pbt
2650: WHERE pbt.balance_name = c_balance_name
2651: AND pbd.database_item_suffix = c_dim_name
2652: AND pbt.balance_type_id = pdb.balance_type_id