DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_USER_COLUMNS

Line 7169: ,pay_user_columns puc

7165: select pucf.VALUE
7166: into l_g_rate
7167: from pay_user_tables put
7168: ,pay_user_rows_f pur
7169: ,pay_user_columns puc
7170: ,pay_user_column_instances_f pucf
7171: where put.USER_TABLE_NAME = 'NO_GLOBAL_CONSTANTS'
7172: and pur.ROW_LOW_RANGE_OR_NAME = 'NATIONAL_INSURANCE_BASE_RATE'
7173: and puc.USER_COLUMN_NAME = 'Value'

Line 7348: ,pay_user_columns puc

7344: SELECT pucf.VALUE
7345: INTO l_value
7346: FROM pay_user_tables put
7347: ,pay_user_rows_f pur
7348: ,pay_user_columns puc
7349: ,pay_user_column_instances_f pucf
7350: WHERE put.USER_TABLE_NAME = p_usertable_name
7351: AND pur.ROW_LOW_RANGE_OR_NAME = p_exact_text
7352: AND puc.USER_COLUMN_NAME = p_usertable_colname