APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_CMN_BOE_HDRS

Line 1913: from JAI_CMN_BOE_HDRS jbh

1909: cursor c_ja_in_boe_hdr (cp_organization_id number, cp_inventory_item_id number) is
1910: select boe_id,
1911: ( nvl(boe_amount, 0) - nvl(amount_applied, 0) - nvl(amount_written_off, 0) )
1912: available_amount
1913: from JAI_CMN_BOE_HDRS jbh
1914: where organization_id = p_organization_id
1915: and ( nvl(boe_amount, 0) - nvl(amount_applied, 0) - nvl(amount_written_off, 0) ) > 0
1916: and ( ( nvl(consolidated_flag, 'Y') = 'Y' )
1917: or

Line 1988: update JAI_CMN_BOE_HDRS

1984: );
1985:
1986: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1987: /* update the boe header amount */
1988: update JAI_CMN_BOE_HDRS
1989: set amount_applied = nvl(amount_applied, 0) + ln_boe_amount_to_apply,
1990: last_update_date = sysdate,
1991: last_updated_by = fnd_global.user_id,
1992: last_update_login = fnd_global.user_id

Line 2122: update JAI_CMN_BOE_HDRS

2118: );
2119:
2120: /* update the boe header amount */
2121: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2122: update JAI_CMN_BOE_HDRS
2123: set amount_applied = nvl(amount_applied, 0) + ln_boe_amount_to_unapply,
2124: last_update_date = sysdate,
2125: last_updated_by = fnd_global.user_id,
2126: last_update_login = fnd_global.user_id