DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_USER_COLUMNS

Line 372: FROM pay_user_columns

368: c_user_col_name VARCHAR2
369: )
370: IS
371: SELECT user_column_id
372: FROM pay_user_columns
373: WHERE user_table_id = c_user_table_id
374: AND user_column_name = c_user_col_name
375: AND ( (business_group_id IS NULL AND legislation_code IS NULL)
376: OR ( business_group_id IS NULL

Line 603: FROM pay_user_columns puc, pay_user_column_instances_f puci

599: c_effective_date DATE
600: )
601: IS
602: SELECT puc.user_column_name
603: FROM pay_user_columns puc, pay_user_column_instances_f puci
604: WHERE puci.user_row_id = c_user_row_id
605: AND puci.user_column_id = puc.user_column_id
606: AND puc.user_table_id = c_user_table_id
607: AND puci.business_group_id = g_business_group_id