APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1182: FROM pay_balance_types pbt

1178: CURSOR c_defined_balance_id
1179: IS
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'

Line 1515: FROM pay_balance_types pbt

1511: CURSOR c_f16_sal_balances
1512: IS
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'

Line 1552: FROM pay_balance_types pbt

1548: CURSOR c_er_excess_pf_balances
1549: IS
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'

Line 1898: FROM pay_balance_types pbt

1894: ,DECODE(pbt.balance_name,'Monthly Furniture Cost',1,
1895: 'Furniture Perquisite',2,
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'

Line 1918: FROM pay_balance_types pbt

1914: SELECT pdb.defined_balance_id balance_id
1915: ,DECODE(pbt.balance_name,'Projected Furniture Cost',1,
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'