APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS_MTH_RET_HDR_H

Line 61: FROM igi_cis_mth_ret_hdr_h audit_hdr,

57: -- And vendor_type_lookup_code in ('PARTNERSHIP','SOLETRADER','COMPANY','TRUST') bug 5620621
58: AND pov.cis_parent_vendor_id is null;*/
59: /*AND pov.vendor_id NOT IN
60: (SELECT audit_lines.vendor_id
61: FROM igi_cis_mth_ret_hdr_h audit_hdr,
62: igi_cis_mth_ret_lines_h audit_lines
63: WHERE audit_hdr.header_id = audit_lines.header_id
64: AND audit_hdr.request_status_code = 'C'
65: AND audit_hdr.period_name = p_in_period

Line 672: from IGI_CIS_MTH_RET_HDR_H hdr_h

668: select nvl(sum(decode(X.nil_return_flag,'Y',1,0)),0) nil_ret_count,
669: nvl(sum(decode(X.nil_return_flag,'N',1,0)),0) non_nil_ret_count
670: from
671: (Select hdr_h.Nil_return_flag nil_return_flag
672: from IGI_CIS_MTH_RET_HDR_H hdr_h
673: where hdr_h.period_name = p_period_name
674: and hdr_h.request_status_code = 'C') X;
675:
676: -- Group the payments according to parent subcontractors

Line 1443: insert into igi_cis_mth_ret_hdr_h

1439: PROCEDURE MOVE_TO_HISTORY(p_header_id IN number,
1440: p_request_status_code IN varchar2)
1441: is
1442: Begin
1443: insert into igi_cis_mth_ret_hdr_h
1444: (HEADER_ID,
1445: ORG_ID,
1446: CIS_SENDER_ID,
1447: TAX_OFFICE_NUMBER,