APPS.PAY_ES_SS_CALCULATION dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 426: l_ret pay_user_column_instances_f.value%type;

422: AND fnd_date.canonical_to_date(hoi2.org_information2) <= c_period_end_date
423: and nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) >= c_period_start_date
424: ORDER BY hoi1.organization_id ;
425: --
426: l_ret pay_user_column_instances_f.value%type;
427: l_tot_days NUMBER;
428: l_days NUMBER;
429: l_act_days NUMBER;
430: l_tmp_days NUMBER;

Line 809: ,pay_user_column_instances_f puci1

805: ,pay_user_columns puc2
806: ,pay_user_columns puc3
807: ,pay_user_rows_f pur
808: ,pay_user_tables put
809: ,pay_user_column_instances_f puci1
810: ,pay_user_column_instances_f puci2
811: ,pay_user_column_instances_f puci3
812: WHERE put.legislation_code = 'ES'
813: AND pur.user_table_id = put.user_table_id

Line 810: ,pay_user_column_instances_f puci2

806: ,pay_user_columns puc3
807: ,pay_user_rows_f pur
808: ,pay_user_tables put
809: ,pay_user_column_instances_f puci1
810: ,pay_user_column_instances_f puci2
811: ,pay_user_column_instances_f puci3
812: WHERE put.legislation_code = 'ES'
813: AND pur.user_table_id = put.user_table_id
814: AND puc1.user_table_id = put.user_table_id

Line 811: ,pay_user_column_instances_f puci3

807: ,pay_user_rows_f pur
808: ,pay_user_tables put
809: ,pay_user_column_instances_f puci1
810: ,pay_user_column_instances_f puci2
811: ,pay_user_column_instances_f puci3
812: WHERE put.legislation_code = 'ES'
813: AND pur.user_table_id = put.user_table_id
814: AND puc1.user_table_id = put.user_table_id
815: AND puc1.user_column_name='REBATE_REDUCTION_ID'

Line 1051: l_ret pay_user_column_instances_f.value%type;

1047: ,pcol_name IN VARCHAR2
1048: ,prow_value IN VARCHAR2
1049: ,peffective_date IN DATE )RETURN NUMBER IS
1050: --
1051: l_ret pay_user_column_instances_f.value%type;
1052: --
1053: BEGIN
1054: --
1055: BEGIN