APPS.GHR_MTO_INT dependencies on GHR_MT_ASSIGNMENTS_F_V

Line 1844: insert into ghr_mt_assignments_f_v (

1840: put_line(' - called locally');
1841: end if;
1842:
1843:
1844: insert into ghr_mt_assignments_f_v (
1845: GHR_INTERFACE_ID,
1846: MT_PROCESS_DATE,
1847: MT_SOURCE,
1848: MT_EFFECTIVE_DATE,

Line 2064: from ghr_mt_assignments_f_v

2060: l_x varchar2(1);
2061:
2062: cursor cur_assignment is
2063: select 'x'
2064: from ghr_mt_assignments_f_v
2065: where mt_name = p_transfer_name
2066: and mt_person_id = to_char(p_a.person_id)
2067: for update;
2068:

Line 2082: update ghr_mt_assignments_f_v

2078: hr_utility.set_message(8301, 'GHR_38549_UPDATE_NOT_FOUND');
2079: hr_utility.raise_error;
2080: end if;
2081:
2082: update ghr_mt_assignments_f_v
2083: set
2084: MT_EFFECTIVE_DATE = p_effective_date,
2085: ASSIGNMENT_ID = nvl(p_a.ASSIGNMENT_ID,ASSIGNMENT_ID),
2086: EFFECTIVE_START_DATE =