APPS.PAY_JP_REPORT_PKG dependencies on PAY_USER_COLUMNS

Line 596: pay_user_columns puc,

592: l_value number := null;
593: CURSOR cur_max_value IS
594: select max(to_number(value))
595: from pay_user_tables put,
596: pay_user_columns puc,
597: pay_user_column_instances_f puci
598: where put.user_table_name = p_user_table_name
599: and puc.user_table_id = put.user_table_id
600: and puc.user_column_name = p_udt_column_name

Line 624: pay_user_columns puc,

620: l_value number := null;
621: CURSOR cur_min_value IS
622: select min(to_number(value))
623: from pay_user_tables put,
624: pay_user_columns puc,
625: pay_user_column_instances_f puci
626: where put.user_table_name = p_user_table_name
627: and puc.user_table_id = put.user_table_id
628: and puc.user_column_name = p_udt_column_name

Line 3426: from pay_user_columns puc,

3422: --
3423: cursor csr_match_value
3424: is
3425: select puci.value
3426: from pay_user_columns puc,
3427: pay_user_rows_f pur,
3428: pay_user_column_instances_f puci
3429: where puc.user_table_id = l_table_id
3430: and puc.user_column_name = p_column

Line 3452: from pay_user_columns puc,

3448: --
3449: cursor csr_range_value
3450: is
3451: select puci.value
3452: from pay_user_columns puc,
3453: pay_user_rows_f pur,
3454: pay_user_column_instances_f puci
3455: where puc.user_table_id = l_table_id
3456: and puc.user_column_name = p_column