APPS.AP_WORKFLOW_PKG dependencies on AP_HOLD_CODES

Line 4299: ap_hold_codes ahc

4295: ahc.hold_instruction
4296: FROM ap_holds_all ah,
4297: ap_invoices_all AI,
4298: po_vendors PV,
4299: ap_hold_codes ahc
4300: WHERE ah.hold_id = p_hold_id
4301: AND AI.invoice_id = ah.invoice_id
4302: AND AI.vendor_id = PV.vendor_id
4303: AND AH.hold_lookup_code = AHC.hold_lookup_code;

Line 4322: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

4318: l_iteration NUMBER;
4319: l_notf_iteration NUMBER;
4320: l_ext_person_id NUMBER(15);
4321: l_ext_user_id NUMBER(15);
4322: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4323: l_total ap_invoices_all.invoice_amount%TYPE;
4324: BEGIN
4325: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4326: Approvers */

Line 4570: ap_hold_codes ahc

4566: FROM ap_holds_all ah,
4567: ap_invoices_all AI,
4568: po_vendors PV,
4569: ap_lookup_codes alk,
4570: ap_hold_codes ahc
4571: WHERE ah.hold_id = p_hold_id
4572: AND alk.lookup_code = ah.hold_lookup_code
4573: AND AI.invoice_id = ah.invoice_id
4574: AND AI.vendor_id = PV.vendor_id

Line 4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

4580: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4581: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4582: l_org_id ap_invoices_all.org_id%TYPE;
4583: l_itemkey VARCHAR2(50);
4584: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4585: l_total ap_invoices_all.invoice_amount%TYPE;
4586:
4587: BEGIN
4588: /* For the main process itemkey has to be hold_id */

Line 6506: ap_hold_codes ahc

6502: END IF;
6503: select aha.release_lookup_code
6504: into l_hold_release_code
6505: from ap_holds_all aha,
6506: ap_hold_codes ahc
6507: where aha.invoice_id = l_invoice_id
6508: and aha.org_id = l_org_id
6509: and aha.hold_lookup_code = ahc.hold_lookup_code
6510: and aha.hold_id = l_hold_id;

Line 6563: ap_hold_codes ahc

6559: END IF;
6560: select nvl(ahc.wait_before_notify_days,0)*24*60
6561: into l_wait_time
6562: from ap_holds_all aha,
6563: ap_hold_codes ahc
6564: where aha.invoice_id = l_invoice_id
6565: and aha.org_id = l_org_id
6566: and aha.hold_lookup_code = ahc.hold_lookup_code
6567: and aha.hold_id = l_hold_id;

Line 6628: ap_hold_codes ahc

6624: nvl(ahc.wait_before_notify_days,0)*24*60
6625: into l_hold_release_code,
6626: l_wait_time
6627: from ap_holds_all aha,
6628: ap_hold_codes ahc
6629: where aha.invoice_id = l_invoice_id
6630: and aha.org_id = l_org_id
6631: and aha.hold_lookup_code = ahc.hold_lookup_code
6632: and aha.hold_id = l_hold_id;