APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_HDR_H

Line 26: FROM igi_cis_mth_ret_hdr_h audit_hdr,

22: -- And vendor_type_lookup_code in ('PARTNERSHIP','SOLETRADER','COMPANY','TRUST') bug 5620621
23: AND pov.cis_parent_vendor_id is null;*/
24: /*AND pov.vendor_id NOT IN
25: (SELECT audit_lines.vendor_id
26: FROM igi_cis_mth_ret_hdr_h audit_hdr,
27: igi_cis_mth_ret_lines_h audit_lines
28: WHERE audit_hdr.header_id = audit_lines.header_id
29: AND audit_hdr.request_status_code = 'C'
30: AND audit_hdr.period_name = p_in_period

Line 454: from IGI_CIS_MTH_RET_HDR_H hdr_h

450: select nvl(sum(decode(X.nil_return_flag,'Y',1,0)),0) nil_ret_count,
451: nvl(sum(decode(X.nil_return_flag,'N',1,0)),0) non_nil_ret_count
452: from
453: (Select hdr_h.Nil_return_flag nil_return_flag
454: from IGI_CIS_MTH_RET_HDR_H hdr_h
455: where hdr_h.period_name = p_period_name
456: and hdr_h.request_status_code = 'C') X;
457:
458: -- Group the payments according to parent subcontractors

Line 1132: insert into igi_cis_mth_ret_hdr_h

1128: PROCEDURE MOVE_TO_HISTORY(p_header_id IN number,
1129: p_request_status_code IN varchar2)
1130: is
1131: Begin
1132: insert into igi_cis_mth_ret_hdr_h
1133: (HEADER_ID,
1134: ORG_ID,
1135: CIS_SENDER_ID,
1136: TAX_OFFICE_NUMBER,