DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on IGI_CIS_VERIFY_HEADERS_T

Line 20: FROM igi_cis_verify_headers_t

16: WHERE header_id = p_header_id;
17: --Bug 5606118
18: CURSOR c_req_id IS
19: SELECT request_id
20: FROM igi_cis_verify_headers_t
21: WHERE header_id = p_header_id;
22: --Bug 5606118
23: BEGIN
24: /* Updating the PO tables */

Line 126: FROM igi_cis_verify_headers_t

122: created_by,
123: cis_sender_id,
124: tax_office_number,
125: paye_reference
126: FROM igi_cis_verify_headers_t
127: WHERE header_id = p_header_id;
128: INSERT INTO igi_cis_verify_lines_h
129: (header_id,
130: action_indicator,

Line 199: DELETE FROM igi_cis_verify_headers_t WHERE header_id = p_header_id;

195: partnership_utr,
196: partnership_name
197: FROM igi_cis_verify_lines_t
198: WHERE header_id = p_header_id;
199: DELETE FROM igi_cis_verify_headers_t WHERE header_id = p_header_id;
200: DELETE FROM igi_cis_verify_lines_t WHERE header_id = p_header_id;
201: END pr_audit_update;
202: /* Function used by Verification UI */
203: FUNCTION igi_cis_is_vendor_paid