APPS.JAI_AP_UTILS_PKG dependencies on FND_PRODUCT_GROUPS

Line 103: FROM fnd_product_groups;

99: Removed select and added cursor.
100: */
101: CURSOR multi_org_installed is
102: SELECT decode(multi_org_flag, 'Y', 1,0) multi_org_cnt
103: FROM fnd_product_groups;
104:
105: p_rep_head_id NUMBER;
106: p_currency_code VARCHAR2(15);
107: cnt_rec NUMBER;

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

139: BEGIN
140:
141: /* Bug 4928860. Added by Lakshmi Gopalsami
142: Removed the count(distinct(org_id) from ap_invoices_all
143: and added the cursor on fnd_product_groups to find out whether
144: multi-org is enabled or not.
145: */
146: OPEN multi_org_installed;
147: FETCH multi_org_installed INTO count_orgs;

Line 366: FROM fnd_product_groups;

362: Removed select and added cursor.
363: */
364: CURSOR multi_org_installed is
365: SELECT decode(multi_org_flag, 'Y', 1,0) multi_org_cnt
366: FROM fnd_product_groups;
367:
368:
369: inv_interface_id NUMBER;
370: inv_line_interface_id NUMBER;

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

449: -------------------------------------------------------------------------------------------------------------------*/
450:
451: /* Bug 4928860. Added by Lakshmi Gopalsami
452: Removed the count(distinct(org_id) from ap_invoices_all
453: and added the cursor on fnd_product_groups to find out whether
454: multi-org is enabled or not.
455: */
456:
457: OPEN multi_org_installed;