APPS.IGI_CIS_IGIPMTHP_PKG dependencies on IGI_CIS_MTH_RET_LINES_T

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 99: delete from igi_cis_mth_ret_lines_t where header_id = 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;
103: RETURN(TRUE);