DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_USER_COLUMNS

Line 1818: pay_user_columns puc,

1814: SELECT 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))
1815: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
1816: FROM pay_user_tables put,
1817: pay_user_rows_F purf,
1818: pay_user_columns puc,
1819: pay_user_column_instances_f pucif
1820: where put.legislation_code='AU'
1821: and put.user_table_name=p_user_table
1822: and put.user_table_id=purf.user_table_id

Line 1975: pay_user_columns puc,

1971: CURSOR csr_get_prev_age IS
1972: SELECT to_number(pucif.value)
1973: FROM pay_user_tables put,
1974: pay_user_rows_F purf,
1975: pay_user_columns puc,
1976: pay_user_column_instances_f pucif
1977: where put.legislation_code='AU'
1978: and put.user_table_name='ETP_PRESERVATION_AGE'
1979: and put.user_table_id=purf.user_table_id