eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1146: FROM pay_balance_types pbt

1142: CURSOR c_defined_balance_id--80D,80DD,80DDB,80G,80GGA
1143: IS
1144: SELECT pdb.defined_balance_id balance_id
1145: ,pbt.balance_name balance_name
1146: FROM pay_balance_types pbt
1147: ,pay_balance_dimensions pbd
1148: ,pay_defined_balances pdb
1149: WHERE pbt.balance_name IN(
1150: 'F16 Deductions Sec 80D'

Line 1168: FROM pay_balance_types pbt

1164: CURSOR c_def_balance_id--80E,80GG and 80U
1165: IS
1166: SELECT pdb.defined_balance_id balance_id
1167: ,pbt.balance_name balance_name
1168: FROM pay_balance_types pbt
1169: ,pay_balance_dimensions pbd
1170: ,pay_defined_balances pdb
1171: WHERE pbt.balance_name IN(
1172: 'F16 Deductions Sec 80CCE'

Line 1914: FROM pay_balance_types pbt

1910: CURSOR c_defined_balance_id
1911: IS
1912: SELECT pdb.defined_balance_id balance_id
1913: ,pbt.balance_name balance_name
1914: FROM pay_balance_types pbt
1915: ,pay_balance_dimensions pbd
1916: ,pay_defined_balances pdb
1917: WHERE pbt.balance_name IN('Long Term Capital Gains'
1918: ,'Short Term Capital Gains'

Line 1934: FROM pay_balance_types pbt

1930: CURSOR c_f16_sal_balances
1931: IS
1932: SELECT pdb.defined_balance_id balance_id
1933: ,pbt.balance_name balance_name
1934: FROM pay_balance_types pbt
1935: ,pay_balance_dimensions pbd
1936: ,pay_defined_balances pdb
1937: WHERE((pbt.balance_name IN('F16 Education Cess till Date'
1938: ,'F16 Sec and HE Cess till Date'

Line 1976: FROM pay_balance_types pbt

1972: CURSOR c_defined_bal_id
1973: IS
1974: SELECT pdb.defined_balance_id balance_id
1975: ,pbt.balance_name balance_name
1976: FROM pay_balance_types pbt
1977: ,pay_balance_dimensions pbd
1978: ,pay_defined_balances pdb
1979: WHERE pbt.balance_name IN(
1980: 'Excess Interest Amount'

Line 2283: FROM pay_balance_types pbt

2279: CURSOR c_defined_bal_id
2280: IS
2281: SELECT pdb.defined_balance_id balance_id
2282: ,pbt.balance_name balance_name
2283: FROM pay_balance_types pbt
2284: ,pay_balance_dimensions pbd
2285: ,pay_defined_balances pdb
2286: WHERE pbt.balance_name IN('Taxable Allowances'
2287: ,'Taxable Perquisites'