APPS.PQP_RATES_HISTORY_CALC dependencies on PAY_USER_COLUMNS

Line 511: ,pay_user_columns sc

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
515: ,pay_user_columns lc

Line 513: ,pay_user_columns uc

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
517: ,pay_user_rows_f ur

Line 515: ,pay_user_columns lc

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'
519: AND ur.user_table_id = ut.user_table_id

Line 724: l_column_name pay_user_columns.user_column_name%TYPE;

720: l_monthly_pay_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
721: l_base_frequency per_time_period_types.number_per_fiscal_year%TYPE:=12;
722: l_pay_frequency_factor NUMBER:= 1;
723: l_contract_factor NUMBER;
724: l_column_name pay_user_columns.user_column_name%TYPE;
725:
726: BEGIN
727:
728: g_debug := hr_utility.debug_enabled;

Line 1653: l_column_name pay_user_columns.USER_COLUMN_NAME%TYPE;

1649: l_input_value_value_set_id pay_input_values_f.value_set_id%TYPE;
1650: l_link_default_value_txt pay_link_input_values_f.default_value%TYPE;
1651: l_entry_value_txt pay_element_entry_values_f.screen_entry_value%TYPE;
1652: l_row_name pay_user_rows_f.ROW_LOW_RANGE_OR_NAME%TYPE;
1653: l_column_name pay_user_columns.USER_COLUMN_NAME%TYPE;
1654: l_element_entry csr_element_entry%ROWTYPE;
1655: --
1656: -- Cursor to get rate from spinal point
1657: --