APPS.GHR_MTO_INT dependencies on GHR_MT_ANALYSIS_CRITERIA_V

Line 1375: insert into ghr_mt_analysis_criteria_v (

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

Line 1466: from ghr_mt_analysis_criteria_v

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

Line 1505: update ghr_mt_analysis_criteria_v

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