APPS.PO_ACCOUNT_HELPER dependencies on FND_LOOKUPS

Line 480: -- If ACRN passed is null, then derive ACRN from fnd_lookups PO_ACRN.

476: -- Derive ACRN for Award and Modification
477: -- Check if call is for Award or Modification
478: -- Populate the po_session_gt table
479: -- Check if input ACRN is not null, then call is_valid_acrn to validate the ACRN.
480: -- If ACRN passed is null, then derive ACRN from fnd_lookups PO_ACRN.
481: -- Get the ACRN value and validate with other ACRNS for the PO.
482: --Parameters:
483: --IN:
484: --p_header_id

Line 728: FROM fnd_lookups

724: (SELECT acrn,
725: rownum rn
726: FROM
727: (SELECT meaning acrn
728: FROM fnd_lookups
729: WHERE lookup_type = 'PO_ACRN'
730: AND enabled_flag ='Y'
731: AND start_date_active<=sysdate
732: AND (end_date_active IS NULL

Line 834: FROM fnd_lookups

830: l_count2 NUMBER;
831: BEGIN
832: SELECT COUNT(1)
833: INTO l_count
834: FROM fnd_lookups
835: WHERE lookup_type = 'PO_ACRN'
836: AND meaning = p_acrn;
837:
838: if l_count > 0 then