DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 1103: ,pay_defined_balances pdb

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'
1107: ,'Deferred Annuity'

Line 1411: ,pay_defined_balances pdb

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'
1415: ,'F16 Gross Salary less Allowances'

Line 1448: ,pay_defined_balances pdb

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'
1452: )

Line 1794: ,pay_defined_balances pdb

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'
1798: )

Line 1814: ,pay_defined_balances pdb

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'
1818: )