APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1976: from po_distributions_all

1972: SELECT costing_group_id
1973: FROM pjm_project_parameters
1974: WHERE project_id in
1975: (select project_id
1976: from po_distributions_all
1977: where po_distribution_id =cp_po_distribution_id
1978: );
1979:
1980: /* cursor to get the material account pertaining to the cost group passed */

Line 2083: FROM po_distributions_all

2079: AND secondary_inventory_name = cp_subinventory_code;
2080:
2081: cursor c_fetch_expense_acct1(cp_po_distribution_id in number) IS
2082: SELECT code_combination_id
2083: FROM po_distributions_all
2084: WHERE po_distribution_id = cp_po_distribution_id;
2085:
2086: CURSOR c_fetch_expense_acct2(cp_po_line_location_id in number) IS
2087: SELECT code_combination_id

Line 2088: FROM po_distributions_all

2084: WHERE po_distribution_id = cp_po_distribution_id;
2085:
2086: CURSOR c_fetch_expense_acct2(cp_po_line_location_id in number) IS
2087: SELECT code_combination_id
2088: FROM po_distributions_all
2089: WHERE line_location_id = cp_po_line_location_id
2090: AND creation_date IN
2091: (SELECT max(creation_date)
2092: FROM po_distributions_all

Line 2092: FROM po_distributions_all

2088: FROM po_distributions_all
2089: WHERE line_location_id = cp_po_line_location_id
2090: AND creation_date IN
2091: (SELECT max(creation_date)
2092: FROM po_distributions_all
2093: WHERE line_location_id = cp_po_line_location_id
2094: );
2095:
2096: CURSOR c_fetch_expense_acct3(cp_organization_id in number, cp_item_id in number) IS