APPS.JAI_AP_UTILS_PKG dependencies on FND_PRODUCT_GROUPS

Line 91: FROM fnd_product_groups;

87: Removed select and added cursor.
88: */
89: CURSOR multi_org_installed is
90: SELECT decode(multi_org_flag, 'Y', 1,0) multi_org_cnt
91: FROM fnd_product_groups;
92:
93: p_rep_head_id NUMBER;
94: p_currency_code VARCHAR2(15);
95: cnt_rec NUMBER;

Line 131: and added the cursor on fnd_product_groups to find out whether

127: BEGIN
128:
129: /* Bug 4928860. Added by Lakshmi Gopalsami
130: Removed the count(distinct(org_id) from ap_invoices_all
131: and added the cursor on fnd_product_groups to find out whether
132: multi-org is enabled or not.
133: */
134: OPEN multi_org_installed;
135: FETCH multi_org_installed INTO count_orgs;

Line 354: FROM fnd_product_groups;

350: Removed select and added cursor.
351: */
352: CURSOR multi_org_installed is
353: SELECT decode(multi_org_flag, 'Y', 1,0) multi_org_cnt
354: FROM fnd_product_groups;
355:
356:
357: inv_interface_id NUMBER;
358: inv_line_interface_id NUMBER;

Line 411: and added the cursor on fnd_product_groups to find out whether

407: -------------------------------------------------------------------------------------------------------------------*/
408:
409: /* Bug 4928860. Added by Lakshmi Gopalsami
410: Removed the count(distinct(org_id) from ap_invoices_all
411: and added the cursor on fnd_product_groups to find out whether
412: multi-org is enabled or not.
413: */
414:
415: OPEN multi_org_installed;