APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 1184: ,pay_defined_balances pdb

1180: SELECT pdb.defined_balance_id balance_id
1181: ,pbt.balance_name balance_name
1182: FROM pay_balance_types pbt
1183: ,pay_balance_dimensions pbd
1184: ,pay_defined_balances pdb
1185: WHERE pbt.balance_name IN('F16 Deductions Sec 80E'
1186: ,'F16 Deductions Sec 80U'
1187: ,'Gross Chapter VIA Deductions'
1188: ,'Deferred Annuity'

Line 1517: ,pay_defined_balances pdb

1513: SELECT pdb.defined_balance_id balance_id
1514: ,pbt.balance_name balance_name
1515: FROM pay_balance_types pbt
1516: ,pay_balance_dimensions pbd
1517: ,pay_defined_balances pdb
1518: WHERE pbt.balance_name IN('F16 Salary Under Section 17'
1519: ,'F16 Profit in lieu of Salary'
1520: ,'F16 Value of Perquisites'
1521: ,'F16 Gross Salary less Allowances'

Line 1554: ,pay_defined_balances pdb

1550: SELECT pdb.defined_balance_id balance_id
1551: ,pbt.balance_name balance_name
1552: FROM pay_balance_types pbt
1553: ,pay_balance_dimensions pbd
1554: ,pay_defined_balances pdb
1555: WHERE pbt.balance_name IN( 'Excess Interest Amount'
1556: ,'Excess PF Amount'
1557: ,'Allowance Amount'
1558: )

Line 1900: ,pay_defined_balances pdb

1896: 'Taxable Perquisites',3) indx
1897: ,pbt.balance_name balance_name
1898: FROM pay_balance_types pbt
1899: ,pay_balance_dimensions pbd
1900: ,pay_defined_balances pdb
1901: WHERE pbt.balance_name IN('Monthly Furniture Cost'
1902: ,'Furniture Perquisite'
1903: ,'Taxable Perquisites'
1904: )

Line 1920: ,pay_defined_balances pdb

1916: 'Projected Furniture Perquisite',2,
1917: 'Taxable Perquisites for Projection',3) indx
1918: FROM pay_balance_types pbt
1919: ,pay_balance_dimensions pbd
1920: ,pay_defined_balances pdb
1921: WHERE pbt.balance_name IN('Projected Furniture Cost'
1922: ,'Projected Furniture Perquisite'
1923: ,'Taxable Perquisites for Projection'
1924: )