APPS.GHR_MTO_INT dependencies on GHR_MT_ANALYSIS_CRITERIA_V

Line 1374: insert into ghr_mt_analysis_criteria_v (

1370:
1371: end if;
1372:
1373:
1374: insert into ghr_mt_analysis_criteria_v (
1375: GHR_INTERFACE_ID,
1376: MT_PROCESS_DATE,
1377: MT_SOURCE,
1378: MT_EFFECTIVE_DATE,

Line 1465: from ghr_mt_analysis_criteria_v

1461: l_x varchar2(1);
1462:
1463: cursor cur_get_special_info is
1464: select 'x'
1465: from ghr_mt_analysis_criteria_v
1466: where mt_name = p_transfer_name
1467: and mt_person_id = to_char(p_person_id)
1468: and mt_information_type = p_flex_name
1469: for update;

Line 1504: update ghr_mt_analysis_criteria_v

1500: p_lookup_code => p_si.segment2);
1501:
1502: end if;
1503:
1504: update ghr_mt_analysis_criteria_v
1505: set
1506: MT_EFFECTIVE_DATE = p_effective_date,
1507: SEGMENT1 = nvl(p_si.SEGMENT1,SEGMENT1),
1508: --SEGMENT2 = nvl(p_si.SEGMENT2,SEGMENT2),