DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 421: FROM pay_user_column_instances_f cin

417: SELECT cin.value basic_pay
418: ,col.user_column_name step_or_rate
419: ,cin.effective_start_date
420: ,cin.effective_end_date
421: FROM pay_user_column_instances_f cin
422: ,pay_user_rows_f urw
423: ,pay_user_columns col
424: WHERE col.user_table_id = p_user_table_id
425: AND urw.user_table_id = p_user_table_id

Line 500: FROM pay_user_column_instances_f cin

496: SELECT cin.value basic_pay
497: ,col.user_column_name step_or_rate
498: ,cin.effective_start_date
499: ,cin.effective_end_date
500: FROM pay_user_column_instances_f cin
501: ,pay_user_rows_f urw
502: ,pay_user_columns col
503: WHERE col.user_table_id = p_user_table_id
504: AND urw.user_table_id = p_user_table_id

Line 588: FROM pay_user_column_instances_f cin

584: SELECT cin.value basic_pay
585: ,col.user_column_name step_or_rate
586: ,cin.effective_start_date
587: ,cin.effective_end_date
588: FROM pay_user_column_instances_f cin
589: ,pay_user_rows_f urw
590: ,pay_user_columns col
591: WHERE col.user_table_id = p_user_table_id
592: AND urw.user_table_id = p_user_table_id

Line 697: FROM pay_user_column_instances_f cin

693: SELECT cin.value basic_pay
694: ,col.user_column_name step_or_rate
695: ,cin.effective_start_date
696: ,cin.effective_end_date
697: FROM pay_user_column_instances_f cin
698: ,pay_user_rows_f urw
699: ,pay_user_columns col
700: WHERE col.user_table_id = p_user_table_id
701: AND urw.user_table_id = p_user_table_id