DBA Data[Home] [Help]

APPS.GHR_MTI_APP dependencies on GHR_MT_INTERFACE_V

Line 89: FROM ghr_mt_interface_v

85: TO_ADJUSTED_BASIC_PAY,
86: TO_TOTAL_SALARY,
87: ASSIGNMENT_NTE_START_DATE,--Bug# 8724192
88: ASSIGNMENT_NTE--Bug# 8724192
89: FROM ghr_mt_interface_v
90: WHERE national_identifier = p_national_identifier
91: AND mt_name = p_mt_name;
92:
93: CURSOR ghr_mt_int_count (p_mt_name varchar2) is

Line 95: from ghr_mt_interface_v

91: AND mt_name = p_mt_name;
92:
93: CURSOR ghr_mt_int_count (p_mt_name varchar2) is
94: select count(*) COUNT
95: from ghr_mt_interface_v
96: where mt_name = p_mt_name
97: and mt_status = 'E';
98:
99: CURSOR PER_EXTRA_CUR (p_mt_id number) is