APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_CMN_BOE_HDRS

Line 2241: from JAI_CMN_BOE_HDRS jbh

2237: cursor c_ja_in_boe_hdr (cp_organization_id number, cp_inventory_item_id number) is
2238: select boe_id,
2239: ( nvl(boe_amount, 0) - nvl(amount_applied, 0) - nvl(amount_written_off, 0) )
2240: available_amount
2241: from JAI_CMN_BOE_HDRS jbh
2242: where organization_id = p_organization_id
2243: and ( nvl(boe_amount, 0) - nvl(amount_applied, 0) - nvl(amount_written_off, 0) ) > 0
2244: and ( ( nvl(consolidated_flag, 'Y') = 'Y' )
2245: or

Line 2316: update JAI_CMN_BOE_HDRS

2312: );
2313:
2314: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2315: /* update the boe header amount */
2316: update JAI_CMN_BOE_HDRS
2317: set amount_applied = nvl(amount_applied, 0) + ln_boe_amount_to_apply,
2318: last_update_date = sysdate,
2319: last_updated_by = fnd_global.user_id,
2320: last_update_login = fnd_global.user_id

Line 2450: update JAI_CMN_BOE_HDRS

2446: );
2447:
2448: /* update the boe header amount */
2449: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2450: update JAI_CMN_BOE_HDRS
2451: set amount_applied = nvl(amount_applied, 0) + ln_boe_amount_to_unapply,
2452: last_update_date = sysdate,
2453: last_updated_by = fnd_global.user_id,
2454: last_update_login = fnd_global.user_id