APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_DEFERRALS_VL

Line 864: SELECT 'x' from ahl_unit_deferrals_vl

860: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type)IS
861:
862: -- check whether any record already exists related to deferral
863: CURSOR deferral_rec_exists_csr(p_unit_effectivity_id IN NUMBER) IS
864: SELECT 'x' from ahl_unit_deferrals_vl
865: WHERE unit_deferral_type = 'DEFERRAL'
866: AND unit_effectivity_id = p_unit_effectivity_id;
867:
868: -- to check whether ue is in production

Line 1442: FROM ahl_unit_deferrals_vl

1438: affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes,attribute_category, attribute1,
1439: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
1440: attribute8, attribute9, attribute10, attribute11, attribute12,
1441: attribute13, attribute14, attribute15
1442: FROM ahl_unit_deferrals_vl
1443: WHERE object_version_number= p_object_version_number
1444: AND unit_deferral_id = p_unit_deferral_id;
1445:
1446: l_df_header_rec AHL_PRD_DF_PVT.df_header_Rec_type;

Line 5089: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP

5085: -- to fetch df_header_rec
5086: CURSOR df_header_info_csr(p_unit_effectivity_id IN NUMBER) IS
5087: SELECT unit_deferral_id, object_version_number, approval_status_code,FLV.meaning approval_status_meaning,defer_reason_code,skip_mr_flag,
5088: affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes, user_deferral_type, DTYP.meaning user_deferral_mean
5089: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP
5090: WHERE unit_deferral_type = 'DEFERRAL'
5091: AND unit_effectivity_id = p_unit_effectivity_id
5092: AND FLV.lookup_code = approval_status_code
5093: AND FLV.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'