APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 1183: ,pay_balance_dimensions pbd

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

Line 1516: ,pay_balance_dimensions pbd

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

Line 1553: ,pay_balance_dimensions pbd

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

Line 1899: ,pay_balance_dimensions pbd

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

Line 1919: ,pay_balance_dimensions pbd

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