APPS.PAY_JP_REPORT_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 597: pay_user_column_instances_f puci

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
601: and puci.user_column_id = puc.user_column_id

Line 625: pay_user_column_instances_f puci

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
629: and puci.user_column_id = puc.user_column_id

Line 3411: o_value pay_user_column_instances_f.value%type;

3407: --
3408: l_table_id number;
3409: l_range_or_match pay_user_tables.range_or_match%type;
3410: l_user_key_units pay_user_tables.user_key_units%type;
3411: o_value pay_user_column_instances_f.value%type;
3412: --
3413: cursor csr_udt
3414: is
3415: select put.user_table_id,

Line 3428: pay_user_column_instances_f puci

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
3431: and nvl(puc.business_group_id,p_business_group_id) = p_business_group_id
3432: and nvl(puc.legislation_code,c_legislation_code) = c_legislation_code

Line 3454: pay_user_column_instances_f puci

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
3457: and nvl(puc.business_group_id,p_business_group_id) = p_business_group_id
3458: and nvl(puc.legislation_code,c_legislation_code) = c_legislation_code