DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 1140: ,pay_balance_dimensions pbd

1136: IS
1137: SELECT pdb.defined_balance_id balance_id
1138: ,pbt.balance_name balance_name
1139: FROM pay_balance_types pbt
1140: ,pay_balance_dimensions pbd
1141: ,pay_defined_balances pdb
1142: WHERE pbt.balance_name IN(
1143: 'F16 Deductions Sec 80D'
1144: ,'F16 Deductions Sec 80DD'

Line 1161: ,pay_balance_dimensions pbd

1157: IS
1158: SELECT pdb.defined_balance_id balance_id
1159: ,pbt.balance_name balance_name
1160: FROM pay_balance_types pbt
1161: ,pay_balance_dimensions pbd
1162: ,pay_defined_balances pdb
1163: WHERE pbt.balance_name IN(
1164: 'F16 Deductions Sec 80CCE'
1165: ,'F16 Deductions Sec 80E'

Line 1898: ,pay_balance_dimensions pbd

1894: IS
1895: SELECT pdb.defined_balance_id balance_id
1896: ,pbt.balance_name balance_name
1897: FROM pay_balance_types pbt
1898: ,pay_balance_dimensions pbd
1899: ,pay_defined_balances pdb
1900: WHERE pbt.balance_name IN('Long Term Capital Gains'
1901: ,'Short Term Capital Gains'
1902: ,'Capital Gains'

Line 1918: ,pay_balance_dimensions pbd

1914: IS
1915: SELECT pdb.defined_balance_id balance_id
1916: ,pbt.balance_name balance_name
1917: FROM pay_balance_types pbt
1918: ,pay_balance_dimensions pbd
1919: ,pay_defined_balances pdb
1920: WHERE((pbt.balance_name IN('F16 Education Cess till Date'
1921: ,'F16 Sec and HE Cess till Date'
1922: ,'F16 Surcharge till Date'

Line 1960: ,pay_balance_dimensions pbd

1956: IS
1957: SELECT pdb.defined_balance_id balance_id
1958: ,pbt.balance_name balance_name
1959: FROM pay_balance_types pbt
1960: ,pay_balance_dimensions pbd
1961: ,pay_defined_balances pdb
1962: WHERE pbt.balance_name IN(
1963: 'Excess Interest Amount'
1964: ,'Excess PF Amount'

Line 2230: ,pay_balance_dimensions pbd

2226: IS
2227: SELECT pdb.defined_balance_id balance_id
2228: ,pbt.balance_name balance_name
2229: FROM pay_balance_types pbt
2230: ,pay_balance_dimensions pbd
2231: ,pay_defined_balances pdb
2232: WHERE pbt.balance_name IN('Taxable Allowances'
2233: ,'Taxable Perquisites'
2234: ,'Monthly Furniture Cost'