APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 500: l_business_group_id pay_user_column_instances_f.business_group_id%TYPE;

496: l_service_factor VARCHAR2(80);
497: l_lower VARCHAR2(80);
498: l_upper VARCHAR2(80);
499: l_column_name VARCHAR2(80);
500: l_business_group_id pay_user_column_instances_f.business_group_id%TYPE;
501:
502: --
503: -- Cursor to get Service History Factor
504: --

Line 510: FROM pay_user_column_instances_f sci

506: IS
507: SELECT sci.VALUE
508: ,lci.VALUE
509: ,uci.VALUE
510: FROM pay_user_column_instances_f sci
511: ,pay_user_columns sc
512: ,pay_user_column_instances_f uci
513: ,pay_user_columns uc
514: ,pay_user_column_instances_f lci

Line 512: ,pay_user_column_instances_f uci

508: ,lci.VALUE
509: ,uci.VALUE
510: FROM pay_user_column_instances_f sci
511: ,pay_user_columns sc
512: ,pay_user_column_instances_f uci
513: ,pay_user_columns uc
514: ,pay_user_column_instances_f lci
515: ,pay_user_columns lc
516: ,pay_user_tables ut

Line 514: ,pay_user_column_instances_f lci

510: FROM pay_user_column_instances_f sci
511: ,pay_user_columns sc
512: ,pay_user_column_instances_f uci
513: ,pay_user_columns uc
514: ,pay_user_column_instances_f lci
515: ,pay_user_columns lc
516: ,pay_user_tables ut
517: ,pay_user_rows_f ur
518: WHERE ut.user_table_name = 'PQP_CONTRACT_TYPES'