3128: open c_full_assignment(p_assignment_id2, p_effective_date2);
3129: fetch c_full_assignment into l_asg2;
3130: close c_full_assignment;
3131:
3132: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3129: fetch c_full_assignment into l_asg2;
3130: close c_full_assignment;
3131:
3132: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3130: close c_full_assignment;
3131:
3132: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3131:
3132: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3132: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3133: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3134: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3135: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3136: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3137: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3138: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3139: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3140: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3141: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3142: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3143: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3144: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3145: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3146: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3147: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3148: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3149: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3150: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3151: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3152: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3153: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3154: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3155: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3156: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3157: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3158: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3159: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3160: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3161: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3162: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3163: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3164: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3165: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3166: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3167: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3168: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3169: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3170: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3171: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3172: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3173: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3174: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3175: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3176: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3177: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3178: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3179: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3180: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3181: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3182: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3183: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3184: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3185: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3186: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3187: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3188: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3189: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3190: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3191: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3192: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3193: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3194: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3195: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3196: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3197: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3198: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3199: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3200: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3201: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3202: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3203: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3204: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3205: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3206: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3207: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3208: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3209: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3210: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3211: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3212: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3213: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3214: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3215: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3216: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3217: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3218: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3219: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3220: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3221: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3222: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3223: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3224: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3225: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3226: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3227: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3228: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3229: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3230: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3231: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3232: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3233: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3234: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3235: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3280: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3281: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3282: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3283: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3284: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3285: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3286: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3287: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3288: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3289: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3290: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3291: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3292: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3293: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3294: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3295: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3296: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3297: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3298: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3299: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3300: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3301: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3302: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3303: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3304: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3305: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3306: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3307: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3308: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3309: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3310: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3311: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3312: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3313: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3314: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3315: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3323: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3316: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3323: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3324: ) then
3317: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3323: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3324: ) then
3325: hr_utility.set_location(l_proc, 20);
3318: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3323: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3324: ) then
3325: hr_utility.set_location(l_proc, 20);
3326: l_return := TRUE;
3319: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3320: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3321: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3322: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3323: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3324: ) then
3325: hr_utility.set_location(l_proc, 20);
3326: l_return := TRUE;
3327: end if;