DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 1147: ,pay_balance_dimensions pbd

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'
1151: ,'F16 Deductions Sec 80DD'

Line 1169: ,pay_balance_dimensions pbd

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'
1173: ,'F16 Deductions Sec 80E'

Line 1915: ,pay_balance_dimensions pbd

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'
1919: ,'Capital Gains'

Line 1935: ,pay_balance_dimensions pbd

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'
1939: ,'F16 Surcharge till Date'

Line 1977: ,pay_balance_dimensions pbd

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'
1981: ,'Excess PF Amount'

Line 2284: ,pay_balance_dimensions pbd

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'
2288: ,'Monthly Furniture Cost'