APPS.AP_WFAPPROVAL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 83: FROM ap_invoice_distributions_all

79: BEGIN
80:
81: SELECT dist_code_combination_id,set_of_books_id
82: INTO l_ccid,l_sob
83: FROM ap_invoice_distributions_all
84: WHERE invoice_distribution_id=p_dist_id;
85:
86: SELECT chart_of_accounts_id
87: INTO l_chart_of_accounts_id

Line 166: FROM ap_invoice_distributions

162: IF l_check_PO_match = 'Y' THEN
163:
164: SELECT count(invoice_distribution_id)
165: INTO l_po_count
166: FROM ap_invoice_distributions
167: WHERE po_distribution_id is null
168: AND invoice_id = substr(itemkey, 1, instr(itemkey,'_')-1);
169:
170:

Line 814: FROM ap_invoice_distributions

810: WHERE vendor_site_id = l_vendor_site_id;
811:
812: SELECT count(invoice_distribution_id)
813: INTO l_po_count
814: FROM ap_invoice_distributions
815: WHERE invoice_id = l_invoice_id
816: and po_distribution_id is not null;
817:
818: IF l_po_count >1 THEN

Line 827: FROM ap_invoice_distributions aid,

823: AND lookup_type = 'NLS TRANSLATION';
824: ELSIF l_po_count = 1 THEN
825: SELECT poh.segment1
826: INTO l_po_num
827: FROM ap_invoice_distributions aid,
828: po_distributions pod,
829: po_headers poh
830: WHERE aid.invoice_id = l_invoice_id
831: AND aid.po_distribution_id = pod.po_distribution_id

Line 1048: FROM ap_invoice_distributions_all

1044: ELSIF p_attribute_name = 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
1045:
1046: SELECT count(invoice_distribution_id)
1047: INTO l_count_pa_rel
1048: FROM ap_invoice_distributions_all
1049: WHERE invoice_id = p_invoice_id
1050: AND project_id is not null;
1051:
1052: IF l_count_pa_rel >0 THEN

Line 1068: FROM ap_invoice_distributions_all aid,

1064: /* SELECT employee_number
1065: INTO l_return_val
1066: FROM per_all_people_f pap
1067: WHERE person_id = (SELECT ph.agent_id
1068: FROM ap_invoice_distributions_all aid,
1069: po_distributions_all pd,
1070: po_headers_all ph
1071: WHERE pd.po_distribution_id =
1072: aid.po_distribution_id

Line 1082: AP_INVOICE_DISTRIBUTIONS_ALL AID,

1078: */
1079: --added for bug 13576488
1080: SELECT Pap.EMPLOYEE_NUMBER
1081: into l_return_val FROM
1082: AP_INVOICE_DISTRIBUTIONS_ALL AID,
1083: PO_DISTRIBUTIONS_ALL PD,
1084: PO_HEADERS_ALL PH,
1085: PER_ALL_PEOPLE_F PAP
1086: WHERE AID.INVOICE_DISTRIBUTION_ID = p_dist_id

Line 1101: FROM ap_invoice_distributions_all aid,

1097: /* SELECT employee_number
1098: INTO l_return_val
1099: FROM per_all_people_f pap
1100: WHERE person_id = (SELECT pd.deliver_to_person_id
1101: FROM ap_invoice_distributions_all aid,
1102: po_distributions_all pd
1103: WHERE pd.po_distribution_id =
1104: aid.po_distribution_id
1105: AND aid.invoice_distribution_id =

Line 1113: FROM ap_invoice_distributions_all aid,

1109: */
1110: --added for bug 13576488
1111: SELECT pap.employee_number
1112: into l_return_val
1113: FROM ap_invoice_distributions_all aid,
1114: po_distributions_all pd,
1115: per_all_people_f pap
1116: WHERE pd.po_distribution_id =aid.po_distribution_id
1117: AND aid.invoice_distribution_id =p_dist_id