APPS.AP_WORKFLOW_PKG dependencies on AP_HOLD_CODES

Line 4426: ap_hold_codes ahc

4422: ahc.hold_instruction
4423: FROM ap_holds_all ah,
4424: ap_invoices_all AI,
4425: po_vendors PV,
4426: ap_hold_codes ahc
4427: WHERE ah.hold_id = p_hold_id
4428: AND AI.invoice_id = ah.invoice_id
4429: AND AI.vendor_id = PV.vendor_id
4430: AND AH.hold_lookup_code = AHC.hold_lookup_code;

Line 4449: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

4445: l_iteration NUMBER;
4446: l_notf_iteration NUMBER;
4447: l_ext_person_id NUMBER(15);
4448: l_ext_user_id NUMBER(15);
4449: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4450: l_total ap_invoices_all.invoice_amount%TYPE;
4451: BEGIN
4452: l_notf_iteration := 1; /* For Now Hold Approval has only one round of
4453: Approvers */

Line 4702: ap_hold_codes ahc

4698: FROM ap_holds_all ah,
4699: ap_invoices_all AI,
4700: po_vendors PV,
4701: ap_lookup_codes alk,
4702: ap_hold_codes ahc
4703: WHERE ah.hold_id = p_hold_id
4704: AND alk.lookup_code = ah.hold_lookup_code
4705: AND AI.invoice_id = ah.invoice_id
4706: AND AI.vendor_id = PV.vendor_id

Line 4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;

4712: l_invoice_id ap_invoices_all.invoice_id%TYPE;
4713: l_hold_type ap_lookup_codes.displayed_field%TYPE;
4714: l_org_id ap_invoices_all.org_id%TYPE;
4715: l_itemkey VARCHAR2(50);
4716: l_hold_instr ap_hold_codes.hold_instruction%TYPE;
4717: l_total ap_invoices_all.invoice_amount%TYPE;
4718:
4719: BEGIN
4720: /* For the main process itemkey has to be hold_id */

Line 6774: ap_hold_codes ahc

6770: END IF;
6771: select aha.release_lookup_code
6772: into l_hold_release_code
6773: from ap_holds_all aha,
6774: ap_hold_codes ahc
6775: where aha.invoice_id = l_invoice_id
6776: and aha.org_id = l_org_id
6777: and aha.hold_lookup_code = ahc.hold_lookup_code
6778: and aha.hold_id = l_hold_id;

Line 6831: ap_hold_codes ahc

6827: END IF;
6828: select nvl(ahc.wait_before_notify_days,0) -- Bug 10090981 *24*60
6829: into l_wait_time
6830: from ap_holds_all aha,
6831: ap_hold_codes ahc
6832: where aha.invoice_id = l_invoice_id
6833: and aha.org_id = l_org_id
6834: and aha.hold_lookup_code = ahc.hold_lookup_code
6835: and aha.hold_id = l_hold_id;

Line 6896: ap_hold_codes ahc

6892: nvl(ahc.reminder_days,0) -- Bug 10090981 *24*60 --Bug8839774
6893: into l_hold_release_code,
6894: l_wait_time
6895: from ap_holds_all aha,
6896: ap_hold_codes ahc
6897: where aha.invoice_id = l_invoice_id
6898: and aha.org_id = l_org_id
6899: and aha.hold_lookup_code = ahc.hold_lookup_code
6900: and aha.hold_id = l_hold_id;