APPS.OTA_TRAINING_RECORD dependencies on HR_GENERAL

Line 857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

853: a.tav_information18,
854: a.tav_information19,
855: a.tav_information20,
856: a.Version_Code Activity_Version_Code,
857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
858: a.professional_credits,
859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
860: a.Controlling_Person_Id Controlling_Person_Id,
861: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS

Line 859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

855: a.tav_information20,
856: a.Version_Code Activity_Version_Code,
857: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
858: a.professional_credits,
859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
860: a.Controlling_Person_Id Controlling_Person_Id,
861: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS
862: ,D.BOOKING_ID
863: ,D.DELEGATE_PERSON_ID

Line 1030: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1026: a.tav_information18,
1027: a.tav_information19,
1028: a.tav_information20,
1029: a.Version_Code Activity_Version_Code,
1030: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1031: a.professional_credits,
1032: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1033: a.Controlling_Person_Id Controlling_Person_Id,
1034: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS

Line 1032: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1028: a.tav_information20,
1029: a.Version_Code Activity_Version_Code,
1030: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1031: a.professional_credits,
1032: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1033: a.Controlling_Person_Id Controlling_Person_Id,
1034: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS
1035: ,D.BOOKING_ID
1036: ,D.DELEGATE_PERSON_ID

Line 1174: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1170: a.tav_information18,
1171: a.tav_information19,
1172: a.tav_information20,
1173: a.Version_Code Activity_Version_Code,
1174: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1175: a.professional_credits,
1176: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1177: a.Controlling_Person_Id Controlling_Person_Id
1178: FROM ota_activity_versions_vl a

Line 1176: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1172: a.tav_information20,
1173: a.Version_Code Activity_Version_Code,
1174: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1175: a.professional_credits,
1176: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1177: a.Controlling_Person_Id Controlling_Person_Id
1178: FROM ota_activity_versions_vl a
1179: WHERE a.activity_version_id = p_course_id;
1180: l_activity_rec activity_rectype;

Line 1266: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,

1262: a.tav_information18,
1263: a.tav_information19,
1264: a.tav_information20,
1265: a.Version_Code Activity_Version_Code,
1266: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1267: a.professional_credits,
1268: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1269: a.Controlling_Person_Id Controlling_Person_Id,
1270: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS

Line 1268: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,

1264: a.tav_information20,
1265: a.Version_Code Activity_Version_Code,
1266: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1267: a.professional_credits,
1268: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1269: a.Controlling_Person_Id Controlling_Person_Id,
1270: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), ST.NAME) STATUS
1271: ,D.BOOKING_ID
1272: ,D.DELEGATE_PERSON_ID