APPS.HREMPTER dependencies on HR_API

Line 3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)

3146: open c_full_assignment(p_assignment_id2, p_effective_date2);
3147: fetch c_full_assignment into l_asg2;
3148: close c_full_assignment;
3149:
3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)

Line 3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)

3147: fetch c_full_assignment into l_asg2;
3148: close c_full_assignment;
3149:
3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)

Line 3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)

3148: close c_full_assignment;
3149:
3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)

Line 3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)

3149:
3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)

Line 3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)

3150: if ( nvl(l_asg1.RECRUITER_ID,hr_api.g_number)
3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

Line 3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)

3151: = nvl(l_asg2.RECRUITER_ID,hr_api.g_number)
3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

Line 3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)

3152: and nvl(l_asg1.GRADE_ID,hr_api.g_number)
3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)

Line 3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)

3153: = nvl(l_asg2.GRADE_ID,hr_api.g_number)
3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)

Line 3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

3154: and nvl(l_asg1.POSITION_ID,hr_api.g_number)
3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)

Line 3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)

3155: = nvl(l_asg2.POSITION_ID,hr_api.g_number)
3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)

Line 3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)

3156: and nvl(l_asg1.JOB_ID,hr_api.g_number)
3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)

Line 3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)

3157: = nvl(l_asg2.JOB_ID,hr_api.g_number)
3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)

Line 3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)

3158: and nvl(l_asg1.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)

Line 3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)

3159: = nvl(l_asg2.ASSIGNMENT_STATUS_TYPE_ID,hr_api.g_number)
3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)

Line 3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)

3160: and nvl(l_asg1.PAYROLL_ID,hr_api.g_number)
3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

Line 3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)

3161: = nvl(l_asg2.PAYROLL_ID,hr_api.g_number)
3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

Line 3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)

3162: and nvl(l_asg1.LOCATION_ID,hr_api.g_number)
3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)

Line 3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)

3163: = nvl(l_asg2.LOCATION_ID,hr_api.g_number)
3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)

Line 3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

3164: and nvl(l_asg1.PERSON_REFERRED_BY_ID,hr_api.g_number)
3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

Line 3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)

3165: = nvl(l_asg2.PERSON_REFERRED_BY_ID,hr_api.g_number)
3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

Line 3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)

3166: and nvl(l_asg1.SUPERVISOR_ID,hr_api.g_number)
3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)

Line 3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)

3167: = nvl(l_asg2.SUPERVISOR_ID,hr_api.g_number)
3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)

Line 3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

3168: and nvl(l_asg1.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)

Line 3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)

3169: = nvl(l_asg2.SPECIAL_CEILING_STEP_ID,hr_api.g_number)
3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)

Line 3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)

3170: and nvl(l_asg1.PERSON_ID,hr_api.g_number)
3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)

Line 3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)

3171: = nvl(l_asg2.PERSON_ID,hr_api.g_number)
3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)

Line 3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)

3172: and nvl(l_asg1.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

Line 3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)

3173: = nvl(l_asg2.RECRUITMENT_ACTIVITY_ID,hr_api.g_number)
3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

Line 3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)

3174: and nvl(l_asg1.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)

Line 3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)

3175: = nvl(l_asg2.SOURCE_ORGANIZATION_ID,hr_api.g_number)
3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)

Line 3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

3176: and nvl(l_asg1.ORGANIZATION_ID,hr_api.g_number)
3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)

Line 3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)

3177: = nvl(l_asg2.ORGANIZATION_ID,hr_api.g_number)
3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)

Line 3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)

3178: and nvl(l_asg1.PEOPLE_GROUP_ID,hr_api.g_number)
3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)

Line 3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)

3179: = nvl(l_asg2.PEOPLE_GROUP_ID,hr_api.g_number)
3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)

Line 3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)

3180: and nvl(l_asg1.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)

Line 3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)

3181: = nvl(l_asg2.SOFT_CODING_KEYFLEX_ID,hr_api.g_number)
3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)

Line 3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)

3182: and nvl(l_asg1.VACANCY_ID,hr_api.g_number)
3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)

Line 3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)

3183: = nvl(l_asg2.VACANCY_ID,hr_api.g_number)
3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)

Line 3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)

3184: and nvl(l_asg1.PAY_BASIS_ID,hr_api.g_number)
3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)

Line 3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)

3185: = nvl(l_asg2.PAY_BASIS_ID,hr_api.g_number)
3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)

Line 3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)

3186: and nvl(l_asg1.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)

Line 3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)

3187: = nvl(l_asg2.ASSIGNMENT_SEQUENCE,hr_api.g_number)
3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)

Line 3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)

3188: and nvl(l_asg1.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)

Line 3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)

3189: = nvl(l_asg2.ASSIGNMENT_TYPE, hr_api.g_varchar2)
3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)

Line 3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)

3190: and nvl(l_asg1.PRIMARY_FLAG, hr_api.g_varchar2)
3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)

Line 3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)

3191: = nvl(l_asg2.PRIMARY_FLAG, hr_api.g_varchar2)
3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)

Line 3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)

3192: and nvl(l_asg1.APPLICATION_ID,hr_api.g_number)
3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)

Line 3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)

3193: = nvl(l_asg2.APPLICATION_ID,hr_api.g_number)
3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)

Line 3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)

3194: and nvl(l_asg1.ASSIGNMENT_NUMBER,hr_api.g_number)
3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)

Line 3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)

3195: = nvl(l_asg2.ASSIGNMENT_NUMBER,hr_api.g_number)
3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)

Line 3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)

3196: and nvl(l_asg1.CHANGE_REASON, hr_api.g_varchar2)
3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)

Line 3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)

3197: = nvl(l_asg2.CHANGE_REASON, hr_api.g_varchar2)
3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)

Line 3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)

3198: and nvl(l_asg1.COMMENT_ID,hr_api.g_number)
3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)

Line 3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)

3199: = nvl(l_asg2.COMMENT_ID,hr_api.g_number)
3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)

Line 3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)

3200: and nvl(l_asg1.DATE_PROBATION_END, hr_api.g_date)
3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)

Line 3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)

3201: = nvl(l_asg2.DATE_PROBATION_END, hr_api.g_date)
3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)

Line 3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)

3202: and nvl(l_asg1.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)

Line 3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)

3203: = nvl(l_asg2.DEFAULT_CODE_COMB_ID,hr_api.g_number)
3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)

Line 3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)

3204: and nvl(l_asg1.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)

Line 3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)

3205: = nvl(l_asg2.EMPLOYMENT_CATEGORY, hr_api.g_varchar2)
3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)

Line 3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)

3206: and nvl(l_asg1.FREQUENCY, hr_api.g_varchar2)
3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)

Line 3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)

3207: = nvl(l_asg2.FREQUENCY, hr_api.g_varchar2)
3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)

Line 3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)

3208: and nvl(l_asg1.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

Line 3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)

3209: = nvl(l_asg2.INTERNAL_ADDRESS_LINE, hr_api.g_varchar2)
3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

Line 3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)

3210: and nvl(l_asg1.MANAGER_FLAG, hr_api.g_varchar2)
3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)

Line 3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)

3211: = nvl(l_asg2.MANAGER_FLAG, hr_api.g_varchar2)
3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)

Line 3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

3212: and nvl(l_asg1.NORMAL_HOURS,hr_api.g_number)
3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)

Line 3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

3213: = nvl(l_asg2.NORMAL_HOURS,hr_api.g_number)
3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)

Line 3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)

3214: and nvl(l_asg1.PERF_REVIEW_PERIOD,hr_api.g_number)
3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)

Line 3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)

3215: = nvl(l_asg2.PERF_REVIEW_PERIOD,hr_api.g_number)
3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)

Line 3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)

3216: and nvl(l_asg1.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)

Line 3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)

3217: = nvl(l_asg2.PERF_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)

Line 3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)

3218: and nvl(l_asg1.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

Line 3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)

3219: = nvl(l_asg2.PERIOD_OF_SERVICE_ID,hr_api.g_number)
3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

Line 3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)

3220: and nvl(l_asg1.PROBATION_PERIOD,hr_api.g_number)
3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)

Line 3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)

3221: = nvl(l_asg2.PROBATION_PERIOD,hr_api.g_number)
3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)

Line 3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

3222: and nvl(l_asg1.PROBATION_UNIT, hr_api.g_varchar2)
3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)

Line 3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)

3223: = nvl(l_asg2.PROBATION_UNIT, hr_api.g_varchar2)
3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)

Line 3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)

3224: and nvl(l_asg1.SAL_REVIEW_PERIOD,hr_api.g_number)
3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)

Line 3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)

3225: = nvl(l_asg2.SAL_REVIEW_PERIOD,hr_api.g_number)
3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)

Line 3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)

3226: and nvl(l_asg1.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)

Line 3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)

3227: = nvl(l_asg2.SAL_REVIEW_PERIOD_FREQUENCY, hr_api.g_varchar2)
3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)

Line 3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)

3228: and nvl(l_asg1.SET_OF_BOOKS_ID,hr_api.g_number)
3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)

Line 3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)

3229: = nvl(l_asg2.SET_OF_BOOKS_ID,hr_api.g_number)
3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)

Line 3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)

3230: and nvl(l_asg1.SOURCE_TYPE, hr_api.g_varchar2)
3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)

Line 3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)

3231: = nvl(l_asg2.SOURCE_TYPE, hr_api.g_varchar2)
3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)

Line 3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)

3232: and nvl(l_asg1.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)

Line 3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)

3233: = nvl(l_asg2.TIME_NORMAL_FINISH, hr_api.g_varchar2)
3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)

Line 3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)

3234: and nvl(l_asg1.TIME_NORMAL_START, hr_api.g_varchar2)
3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)

Line 3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)

3235: = nvl(l_asg2.TIME_NORMAL_START, hr_api.g_varchar2)
3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)

Line 3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)

3236: and nvl(l_asg1.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)

Line 3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)

3237: = nvl(l_asg2.ASS_ATTRIBUTE_CATEGORY, hr_api.g_varchar2)
3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)

Line 3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)

3238: and nvl(l_asg1.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)

Line 3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)

3239: = nvl(l_asg2.ASS_ATTRIBUTE1, hr_api.g_varchar2)
3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)

Line 3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)

3240: and nvl(l_asg1.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)

Line 3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)

3241: = nvl(l_asg2.ASS_ATTRIBUTE2, hr_api.g_varchar2)
3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)

Line 3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)

3242: and nvl(l_asg1.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)

Line 3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)

3243: = nvl(l_asg2.ASS_ATTRIBUTE3, hr_api.g_varchar2)
3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)

Line 3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)

3244: and nvl(l_asg1.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)

Line 3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)

3245: = nvl(l_asg2.ASS_ATTRIBUTE4, hr_api.g_varchar2)
3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)

Line 3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)

3246: and nvl(l_asg1.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)

Line 3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)

3247: = nvl(l_asg2.ASS_ATTRIBUTE5, hr_api.g_varchar2)
3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)

Line 3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)

3248: and nvl(l_asg1.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)

Line 3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)

3249: = nvl(l_asg2.ASS_ATTRIBUTE6, hr_api.g_varchar2)
3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)

Line 3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)

3250: and nvl(l_asg1.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)

Line 3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)

3251: = nvl(l_asg2.ASS_ATTRIBUTE7, hr_api.g_varchar2)
3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)

Line 3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)

3252: and nvl(l_asg1.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)

Line 3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)

3253: = nvl(l_asg2.ASS_ATTRIBUTE8, hr_api.g_varchar2)
3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)

Line 3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)

3254: and nvl(l_asg1.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)

Line 3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)

3255: = nvl(l_asg2.ASS_ATTRIBUTE9, hr_api.g_varchar2)
3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)

Line 3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)

3256: and nvl(l_asg1.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)

Line 3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)

3257: = nvl(l_asg2.ASS_ATTRIBUTE10, hr_api.g_varchar2)
3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)

Line 3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)

3258: and nvl(l_asg1.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)

Line 3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)

3259: = nvl(l_asg2.ASS_ATTRIBUTE11, hr_api.g_varchar2)
3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)

Line 3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)

3260: and nvl(l_asg1.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)

Line 3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)

3261: = nvl(l_asg2.ASS_ATTRIBUTE12, hr_api.g_varchar2)
3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)

Line 3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)

3262: and nvl(l_asg1.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)

Line 3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)

3263: = nvl(l_asg2.ASS_ATTRIBUTE13, hr_api.g_varchar2)
3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)

Line 3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)

3264: and nvl(l_asg1.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)

Line 3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)

3265: = nvl(l_asg2.ASS_ATTRIBUTE14, hr_api.g_varchar2)
3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)

Line 3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)

3266: and nvl(l_asg1.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)

Line 3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)

3267: = nvl(l_asg2.ASS_ATTRIBUTE15, hr_api.g_varchar2)
3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)

Line 3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)

3268: and nvl(l_asg1.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)

Line 3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)

3269: = nvl(l_asg2.ASS_ATTRIBUTE16, hr_api.g_varchar2)
3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)

Line 3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)

3270: and nvl(l_asg1.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)

Line 3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)

3271: = nvl(l_asg2.ASS_ATTRIBUTE17, hr_api.g_varchar2)
3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)

Line 3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)

3272: and nvl(l_asg1.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)

Line 3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)

3273: = nvl(l_asg2.ASS_ATTRIBUTE18, hr_api.g_varchar2)
3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)

Line 3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)

3274: and nvl(l_asg1.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)

Line 3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)

3275: = nvl(l_asg2.ASS_ATTRIBUTE19, hr_api.g_varchar2)
3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)

Line 3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)

3276: and nvl(l_asg1.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)

Line 3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)

3277: = nvl(l_asg2.ASS_ATTRIBUTE20, hr_api.g_varchar2)
3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)

Line 3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)

3278: and nvl(l_asg1.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)

Line 3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)

3279: = nvl(l_asg2.ASS_ATTRIBUTE21, hr_api.g_varchar2)
3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)

Line 3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)

3280: and nvl(l_asg1.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)

Line 3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)

3281: = nvl(l_asg2.ASS_ATTRIBUTE22, hr_api.g_varchar2)
3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)

Line 3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)

3282: and nvl(l_asg1.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)

Line 3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)

3283: = nvl(l_asg2.ASS_ATTRIBUTE23, hr_api.g_varchar2)
3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)

Line 3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)

3284: and nvl(l_asg1.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)

Line 3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)

3285: = nvl(l_asg2.ASS_ATTRIBUTE24, hr_api.g_varchar2)
3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)

Line 3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)

3286: and nvl(l_asg1.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)

Line 3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)

3287: = nvl(l_asg2.ASS_ATTRIBUTE25, hr_api.g_varchar2)
3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)

Line 3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)

3288: and nvl(l_asg1.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)

Line 3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)

3289: = nvl(l_asg2.ASS_ATTRIBUTE26, hr_api.g_varchar2)
3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)

Line 3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)

3290: and nvl(l_asg1.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)

Line 3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)

3291: = nvl(l_asg2.ASS_ATTRIBUTE27, hr_api.g_varchar2)
3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)

Line 3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)

3292: and nvl(l_asg1.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)

Line 3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)

3293: = nvl(l_asg2.ASS_ATTRIBUTE28, hr_api.g_varchar2)
3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)

Line 3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)

3294: and nvl(l_asg1.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)

Line 3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)

3295: = nvl(l_asg2.ASS_ATTRIBUTE29, hr_api.g_varchar2)
3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)

Line 3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)

3296: and nvl(l_asg1.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)

Line 3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)

3297: = nvl(l_asg2.ASS_ATTRIBUTE30, hr_api.g_varchar2)
3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)

Line 3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)

3298: and nvl(l_asg1.TITLE, hr_api.g_varchar2)
3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)

Line 3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)

3299: = nvl(l_asg2.TITLE, hr_api.g_varchar2)
3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)

Line 3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)

3300: and nvl(l_asg1.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

Line 3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)

3301: = nvl(l_asg2.BARGAINING_UNIT_CODE, hr_api.g_varchar2)
3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

Line 3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)

3302: and nvl(l_asg1.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)

Line 3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)

3303: = nvl(l_asg2.LABOUR_UNION_MEMBER_FLAG, hr_api.g_varchar2)
3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)

Line 3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

3304: and nvl(l_asg1.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)

Line 3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)

3305: = nvl(l_asg2.HOURLY_SALARIED_CODE, hr_api.g_varchar2)
3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)

Line 3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)

3306: and nvl(l_asg1.CONTRACT_ID,hr_api.g_number)
3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)

Line 3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)

3307: = nvl(l_asg2.CONTRACT_ID,hr_api.g_number)
3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)

Line 3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)

3308: and nvl(l_asg1.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)

Line 3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)

3309: = nvl(l_asg2.COLLECTIVE_AGREEMENT_ID,hr_api.g_number)
3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)

Line 3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)

3310: and nvl(l_asg1.CAGR_ID_FLEX_NUM,hr_api.g_number)
3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)

Line 3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)

3311: = nvl(l_asg2.CAGR_ID_FLEX_NUM,hr_api.g_number)
3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)

Line 3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)

3312: and nvl(l_asg1.CAGR_GRADE_DEF_ID,hr_api.g_number)
3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)

Line 3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)

3313: = nvl(l_asg2.CAGR_GRADE_DEF_ID,hr_api.g_number)
3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)

Line 3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)

3314: and nvl(l_asg1.ESTABLISHMENT_ID,hr_api.g_number)
3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)

Line 3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)

3315: = nvl(l_asg2.ESTABLISHMENT_ID,hr_api.g_number)
3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)

Line 3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)

3316: and nvl(l_asg1.NOTICE_PERIOD,hr_api.g_number)
3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)

Line 3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)

3317: = nvl(l_asg2.NOTICE_PERIOD,hr_api.g_number)
3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)

Line 3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)

3318: and nvl(l_asg1.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)

Line 3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)

3319: = nvl(l_asg2.NOTICE_PERIOD_UOM, hr_api.g_varchar2)
3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)

Line 3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)

3320: and nvl(l_asg1.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)

Line 3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)

3321: = nvl(l_asg2.EMPLOYEE_CATEGORY, hr_api.g_varchar2)
3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)

Line 3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)

3322: and nvl(l_asg1.WORK_AT_HOME, hr_api.g_varchar2)
3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)

Line 3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)

3323: = nvl(l_asg2.WORK_AT_HOME, hr_api.g_varchar2)
3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)

Line 3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)

3324: and nvl(l_asg1.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)

Line 3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)

3325: = nvl(l_asg2.JOB_POST_SOURCE_NAME, hr_api.g_varchar2)
3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)

Line 3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)

3326: and nvl(l_asg1.POSTING_CONTENT_ID,hr_api.g_number)
3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)

Line 3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)

3327: = nvl(l_asg2.POSTING_CONTENT_ID,hr_api.g_number)
3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)

Line 3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)

3328: and nvl(l_asg1.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)

Line 3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)

3329: = nvl(l_asg2.PERIOD_OF_PLACEMENT_DATE_START, hr_api.g_date)
3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)

Line 3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)

3330: and nvl(l_asg1.VENDOR_ID,hr_api.g_number)
3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)

Line 3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)

3331: = nvl(l_asg2.VENDOR_ID,hr_api.g_number)
3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)

Line 3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)

3332: and nvl(l_asg1.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)

Line 3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)

3333: = nvl(l_asg2.VENDOR_EMPLOYEE_NUMBER, hr_api.g_varchar2)
3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)

Line 3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)

3334: and nvl(l_asg1.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3342: ) then

Line 3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)

3335: = nvl(l_asg2.VENDOR_ASSIGNMENT_NUMBER, hr_api.g_varchar2)
3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3342: ) then
3343: hr_utility.set_location(l_proc, 20);

Line 3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)

3336: and nvl(l_asg1.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3342: ) then
3343: hr_utility.set_location(l_proc, 20);
3344: l_return := TRUE;

Line 3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)

3337: = nvl(l_asg2.ASSIGNMENT_CATEGORY, hr_api.g_varchar2)
3338: and nvl(l_asg1.PROJECT_TITLE, hr_api.g_varchar2)
3339: = nvl(l_asg2.PROJECT_TITLE, hr_api.g_varchar2)
3340: and nvl(l_asg1.APPLICANT_RANK,hr_api.g_number)
3341: = nvl(l_asg2.APPLICANT_RANK,hr_api.g_number)
3342: ) then
3343: hr_utility.set_location(l_proc, 20);
3344: l_return := TRUE;
3345: end if;

Line 4412: ,p_datetrack_mode => hr_api.g_delete_next_change

4408: hr_per_type_usage_internal.delete_person_type_usage
4409: (p_validate => FALSE
4410: ,p_person_type_usage_id => l_per_type_usage_id
4411: ,p_effective_date => p_actual_termination_date
4412: ,p_datetrack_mode => hr_api.g_delete_next_change
4413: ,p_object_version_number => l_ovn
4414: ,p_effective_start_date => l_eff_start_date
4415: ,p_effective_end_date => l_eff_end_date);
4416: else

Line 4453: ,p_datetrack_mode => hr_api.g_delete_next_change

4449: hr_per_type_usage_internal.delete_person_type_usage
4450: (p_validate => FALSE
4451: ,p_person_type_usage_id => l_per_type_usage_id
4452: ,p_effective_date => p_actual_termination_date
4453: ,p_datetrack_mode => hr_api.g_delete_next_change
4454: ,p_object_version_number => l_ovn
4455: ,p_effective_start_date => l_eff_start_date
4456: ,p_effective_end_date => l_eff_end_date);
4457: else