APPS.GHR_MTO_INT dependencies on GHR_MT_ASSIGNMENTS_F_V

Line 1843: insert into ghr_mt_assignments_f_v (

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

Line 2063: from ghr_mt_assignments_f_v

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

Line 2081: update ghr_mt_assignments_f_v

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