DBA Data[Home] [Help]

APPS.GHR_PC_BASIC_PAY dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 404: FROM pay_user_column_instances_f cin

400: SELECT cin.value basic_pay
401: ,col.user_column_name step_or_rate
402: ,cin.effective_start_date
403: ,cin.effective_end_date
404: FROM pay_user_column_instances_f cin
405: ,pay_user_rows_f urw
406: ,pay_user_columns col
407: WHERE col.user_table_id = p_user_table_id
408: AND urw.user_table_id = p_user_table_id

Line 483: FROM pay_user_column_instances_f cin

479: SELECT cin.value basic_pay
480: ,col.user_column_name step_or_rate
481: ,cin.effective_start_date
482: ,cin.effective_end_date
483: FROM pay_user_column_instances_f cin
484: ,pay_user_rows_f urw
485: ,pay_user_columns col
486: WHERE col.user_table_id = p_user_table_id
487: AND urw.user_table_id = p_user_table_id

Line 571: FROM pay_user_column_instances_f cin

567: SELECT cin.value basic_pay
568: ,col.user_column_name step_or_rate
569: ,cin.effective_start_date
570: ,cin.effective_end_date
571: FROM pay_user_column_instances_f cin
572: ,pay_user_rows_f urw
573: ,pay_user_columns col
574: WHERE col.user_table_id = p_user_table_id
575: AND urw.user_table_id = p_user_table_id

Line 680: FROM pay_user_column_instances_f cin

676: SELECT cin.value basic_pay
677: ,col.user_column_name step_or_rate
678: ,cin.effective_start_date
679: ,cin.effective_end_date
680: FROM pay_user_column_instances_f cin
681: ,pay_user_rows_f urw
682: ,pay_user_columns col
683: WHERE col.user_table_id = p_user_table_id
684: AND urw.user_table_id = p_user_table_id