APPS.IGS_AV_GEN_001 dependencies on FND_PROFILE

Line 1953: ,X_ORG_ID => FND_PROFILE.VALUE('ORG_ID')

1949: X_Av_Stnd_Unit_Id => V_AV_UNT.AV_STND_UNIT_ID,
1950: X_Basis_Course_Type => null,
1951: X_Basis_Year => null,
1952: X_Basis_Completion_Ind => null
1953: ,X_ORG_ID => FND_PROFILE.VALUE('ORG_ID')
1954: );
1955: lv_rowid :=null;
1956: END LOOP;
1957:

Line 1966: ,X_ORG_ID => FND_PROFILE.VALUE('ORG_ID')

1962: X_Av_Stnd_Unit_Lvl_Id => V_AV_UNT.AV_STND_UNIT_LVL_ID,
1963: X_Basis_Course_Type => null,
1964: X_Basis_Year => null,
1965: X_Basis_Completion_Ind => null
1966: ,X_ORG_ID => FND_PROFILE.VALUE('ORG_ID')
1967: );
1968: lv_rowid :=null;
1969: END LOOP;
1970: commit;

Line 2055: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))

2051: SELECT 'X'
2052: FROM igs_en_su_attempt
2053: WHERE person_id = p_person_id
2054: AND ((unit_attempt_status IN ('ENROLLED', 'DISCONTIN','COMPLETED','INVALID','UNCONFIRM'))
2055: OR (unit_attempt_status = 'WAITLISTED' AND FND_PROFILE.VALUE('IGS_EN_VAL_WLST') ='Y'))
2056: AND (unit_cd, version_number) IN
2057: (SELECT unit_cd,
2058: version_number
2059: FROM igs_ps_unit_ver