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_AU_TERMINATIONS dependencies on PAY_USER_COLUMNS

Line 1930: pay_user_columns puc,

1926: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
1927: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
1928: FROM pay_user_tables put,
1929: pay_user_rows_F purf,
1930: pay_user_columns puc,
1931: pay_user_column_instances_f pucif
1932: where put.legislation_code='AU'
1933: and put.user_table_name=p_user_table
1934: and put.user_table_id=purf.user_table_id

Line 2087: pay_user_columns puc,

2083: CURSOR csr_get_prev_age IS
2084: SELECT /*+ index(PURF) ORDERED */ to_number(pucif.value) -- bug8647962
2085: FROM pay_user_tables put,
2086: pay_user_rows_F purf,
2087: pay_user_columns puc,
2088: pay_user_column_instances_f pucif
2089: where put.legislation_code='AU'
2090: and put.user_table_name='ETP_PRESERVATION_AGE'
2091: and put.user_table_id=purf.user_table_id

Line 2569: pay_user_columns puc,

2565: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
2566: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
2567: FROM pay_user_tables put,
2568: pay_user_rows_F purf,
2569: pay_user_columns puc,
2570: pay_user_column_instances_f pucif
2571: where put.legislation_code='AU'
2572: and put.user_table_name=p_user_table
2573: and put.user_table_id=purf.user_table_id

Line 3698: pay_user_columns puc,

3694: SELECT /*+ INDEX(PURF) ORDERED */ NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
3695: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
3696: FROM pay_user_tables put,
3697: pay_user_rows_F purf,
3698: pay_user_columns puc,
3699: pay_user_column_instances_f pucif
3700: where put.legislation_code='AU'
3701: and put.user_table_name=p_user_table
3702: and put.user_table_id=purf.user_table_id

Line 3756: from pay_user_tables pt, PAY_USER_COLUMNS pc, PAY_USER_ROWS_F pr, PAY_USER_COLUMN_INSTANCES_F pci

3752: select
3753: pr.row_low_range_or_name low_range,
3754: pr.row_high_range high_range,
3755: pci.value
3756: from pay_user_tables pt, PAY_USER_COLUMNS pc, PAY_USER_ROWS_F pr, PAY_USER_COLUMN_INSTANCES_F pci
3757: where pt.user_table_name = c_user_table_name
3758: and pt.user_table_id = pc.user_table_id
3759: and pt.user_table_id = pr.user_table_id
3760: and pr.user_row_id = pci.user_row_id