APPS.INV_PO_THIRD_PARTY_STOCK_MDTR dependencies on PO_ASL_ATTRIBUTES

Line 899: FROM po_asl_attributes

895: l_asl_id := p_asl_id;
896:
897: SELECT COUNT(*)
898: INTO l_bill_date_elapsed
899: FROM po_asl_attributes
900: WHERE TRUNC(last_billing_date) +
901: NVL(consigned_billing_cycle,0) > TRUNC(SYSDATE)
902: AND asl_id = l_asl_id ;
903:

Line 925: po_asl_attributes

921:
922: -- Update the billing date of the current asl
923:
924: UPDATE
925: po_asl_attributes
926: SET last_billing_date = SYSDATE
927: WHERE asl_id = l_asl_id;
928:
929: END update_asl;