APPS.GHR_PC_BASIC_PAY dependencies on PAY_USER_COLUMNS

Line 406: ,pay_user_columns col

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
409: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
410: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 485: ,pay_user_columns col

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
488: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
489: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 573: ,pay_user_columns col

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
576: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
577: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date

Line 682: ,pay_user_columns col

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
685: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
686: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date