APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1101: FROM pay_balance_types pbt

1097: CURSOR c_defined_balance_id
1098: IS
1099: SELECT pdb.defined_balance_id balance_id
1100: ,pbt.balance_name balance_name
1101: FROM pay_balance_types pbt
1102: ,pay_balance_dimensions pbd
1103: ,pay_defined_balances pdb
1104: WHERE pbt.balance_name IN('F16 Deductions Sec 80E'
1105: ,'F16 Deductions Sec 80U'

Line 1409: FROM pay_balance_types pbt

1405: CURSOR c_f16_sal_balances
1406: IS
1407: SELECT pdb.defined_balance_id balance_id
1408: ,pbt.balance_name balance_name
1409: FROM pay_balance_types pbt
1410: ,pay_balance_dimensions pbd
1411: ,pay_defined_balances pdb
1412: WHERE pbt.balance_name IN('F16 Salary Under Section 17'
1413: ,'F16 Profit in lieu of Salary'

Line 1446: FROM pay_balance_types pbt

1442: CURSOR c_er_excess_pf_balances
1443: IS
1444: SELECT pdb.defined_balance_id balance_id
1445: ,pbt.balance_name balance_name
1446: FROM pay_balance_types pbt
1447: ,pay_balance_dimensions pbd
1448: ,pay_defined_balances pdb
1449: WHERE pbt.balance_name IN( 'Excess Interest Amount'
1450: ,'Excess PF Amount'

Line 1792: FROM pay_balance_types pbt

1788: ,DECODE(pbt.balance_name,'Monthly Furniture Cost',1,
1789: 'Furniture Perquisite',2,
1790: 'Taxable Perquisites',3) indx
1791: ,pbt.balance_name balance_name
1792: FROM pay_balance_types pbt
1793: ,pay_balance_dimensions pbd
1794: ,pay_defined_balances pdb
1795: WHERE pbt.balance_name IN('Monthly Furniture Cost'
1796: ,'Furniture Perquisite'

Line 1812: FROM pay_balance_types pbt

1808: SELECT pdb.defined_balance_id balance_id
1809: ,DECODE(pbt.balance_name,'Projected Furniture Cost',1,
1810: 'Projected Furniture Perquisite',2,
1811: 'Taxable Perquisites for Projection',3) indx
1812: FROM pay_balance_types pbt
1813: ,pay_balance_dimensions pbd
1814: ,pay_defined_balances pdb
1815: WHERE pbt.balance_name IN('Projected Furniture Cost'
1816: ,'Projected Furniture Perquisite'