APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 1102: ,pay_balance_dimensions pbd

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'
1106: ,'Gross Chapter VIA Deductions'

Line 1410: ,pay_balance_dimensions pbd

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'
1414: ,'F16 Value of Perquisites'

Line 1447: ,pay_balance_dimensions pbd

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'
1451: ,'Allowance Amount'

Line 1793: ,pay_balance_dimensions pbd

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'
1797: ,'Taxable Perquisites'

Line 1813: ,pay_balance_dimensions pbd

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'
1817: ,'Taxable Perquisites for Projection'