eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_CIS_IGIPMTHP_PKG dependencies on IGI_CIS_MTH_RET_HDR_T

Line 30: pwhereclause := pwhereclause || ' AND hdr.header_id = (select min(header_id) from IGI_CIS_MTH_RET_HDR_T where period_name = ''' || p_period || '''';

26: --Bug 5933093 start
27: IF (p_period IS NOT NULL ) THEN
28: pwhereclause := pwhereclause || ' AND hdr.period_name = ''' || p_period || '''';
29: IF p_mode = 'P' THEN
30: pwhereclause := pwhereclause || ' AND hdr.header_id = (select min(header_id) from IGI_CIS_MTH_RET_HDR_T where period_name = ''' || p_period || '''';
31: pwhereclause := pwhereclause || ' AND request_status_code = ''P'')';
32: ELSE
33: pwhereclause := pwhereclause || ' AND hdr.header_id = (select min(header_id) from IGI_CIS_MTH_RET_HDR_H where period_name = ''' || p_period || '''';
34: pwhereclause := pwhereclause || ' AND request_status_code = ''C'')';

Line 41: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_T hdr, IGI_CIS_MTH_RET_LINES_T lines, IGI_CIS_MTH_RET_PAY_T pay ';

37: --Bug 5933093 end
38:
39: IF p_mode = 'P' THEN
40: pwhereclause := pwhereclause || ' AND request_status_code = ''P''';
41: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_T hdr, IGI_CIS_MTH_RET_LINES_T lines, IGI_CIS_MTH_RET_PAY_T pay ';
42: ELSE
43: pwhereclause := pwhereclause || ' AND request_status_code = ''C''';
44: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_H hdr, IGI_CIS_MTH_RET_LINES_H lines, IGI_CIS_MTH_RET_PAY_H pay ';
45: END IF ;

Line 95: from igi_cis_mth_ret_hdr_t

91: BEGIN
92: IF p_mode = 'P' and p_del_preview = 'Y' THEN
93: Select min(header_id) --Bug 5933093
94: into l_header_id
95: from igi_cis_mth_ret_hdr_t
96: where period_name = p_period
97: and request_status_code = 'P';
98: delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;
99: delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;

Line 98: delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;

94: into l_header_id
95: from igi_cis_mth_ret_hdr_t
96: where period_name = p_period
97: and request_status_code = 'P';
98: delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;
99: delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;
100: delete from igi_cis_mth_ret_pay_t where header_id = l_header_id;
101: commit;
102: END IF;