DBA Data[Home] [Help]

APPS.AP_WFAPPROVAL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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 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 1067: FROM ap_invoice_distributions_all aid,

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

Line 1085: FROM ap_invoice_distributions_all aid,

1081: SELECT employee_number
1082: INTO l_return_val
1083: FROM per_all_people_f pap
1084: WHERE person_id = (SELECT pd.deliver_to_person_id
1085: FROM ap_invoice_distributions_all aid,
1086: po_distributions_all pd
1087: WHERE pd.po_distribution_id =
1088: aid.po_distribution_id
1089: AND aid.invoice_distribution_id =