DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PAY_USER_COLUMNS

Line 7069: ,pay_user_columns puc

7065: select pucf.VALUE
7066: into l_g_rate
7067: from pay_user_tables put
7068: ,pay_user_rows_f pur
7069: ,pay_user_columns puc
7070: ,pay_user_column_instances_f pucf
7071: where put.USER_TABLE_NAME = 'NO_GLOBAL_CONSTANTS'
7072: and pur.ROW_LOW_RANGE_OR_NAME = 'NATIONAL_INSURANCE_BASE_RATE'
7073: and puc.USER_COLUMN_NAME = 'Value'

Line 7248: ,pay_user_columns puc

7244: SELECT pucf.VALUE
7245: INTO l_value
7246: FROM pay_user_tables put
7247: ,pay_user_rows_f pur
7248: ,pay_user_columns puc
7249: ,pay_user_column_instances_f pucf
7250: WHERE put.USER_TABLE_NAME = p_usertable_name
7251: AND pur.ROW_LOW_RANGE_OR_NAME = p_exact_text
7252: AND puc.USER_COLUMN_NAME = p_usertable_colname