APPS.GHR_MASS_AWARDS_ELIG dependencies on GHR_MASS_AWARDS_ELIG

Line 1: Package Body ghr_mass_awards_elig as

1: Package Body ghr_mass_awards_elig as
2: /* $Header: ghmawelg.pkb 120.1.12010000.3 2008/10/15 10:35:17 utokachi ship $ */
3:
4: Procedure get_eligible_employees
5: (p_mass_award_id in number ,

Line 167: ghr_mass_awards_elig.derive_rel_operator

163: l_old_operator := null;
164: for asg_values in c_asg_values loop
165: l_asg_exists := TRUE;
166: l_new_operator := asg_values.relational_operator;
167: ghr_mass_awards_elig.derive_rel_operator
168: (p_in_rel_operator => asg_values.relational_operator,
169: p_out_rel_operator => l_operator,
170: p_prefix => l_pre,
171: p_suffix => l_suf

Line 284: ghr_mass_awards_elig.derive_rel_operator

280:
281: for pos_kff_values in c_pos_kff_values loop
282: -- l_pos_kff_exists := TRUE;
283:
284: ghr_mass_awards_elig.derive_rel_operator
285: (p_in_rel_operator => pos_kff_values.relational_operator,
286: p_out_rel_operator => l_operator,
287: p_prefix => l_pre,
288: p_suffix => l_suf

Line 420: ghr_mass_awards_elig.derive_rel_operator

416: l_select := 'select 1 from dual where (1 = 1';
417:
418: for pos_grp2_rec in c_pos_grp2_values loop
419:
420: ghr_mass_awards_elig.derive_rel_operator
421: (p_in_rel_operator => pos_grp2_rec.relational_operator,
422: p_out_rel_operator => l_operator,
423: p_prefix => l_pre,
424: p_suffix => l_suf

Line 495: ghr_mass_awards_elig.derive_rel_operator

491: l_select := 'select 1 from dual where (1 = 1';
492:
493: for pos_grp1_rec in c_pos_grp1_values loop
494:
495: ghr_mass_awards_elig.derive_rel_operator
496: (p_in_rel_operator => pos_grp1_rec.relational_operator,
497: p_out_rel_operator => l_operator,
498: p_prefix => l_pre,
499: p_suffix => l_suf

Line 588: ghr_mass_awards_elig.derive_rel_operator

584: l_select := 'select 1 from dual where (1 = 1';
585:
586: for pos_grp1_rec in c_pos_grp1_values loop
587:
588: ghr_mass_awards_elig.derive_rel_operator
589: (p_in_rel_operator => pos_grp1_rec.relational_operator,
590: p_out_rel_operator => l_operator,
591: p_prefix => l_pre,
592: p_suffix => l_suf

Line 676: ghr_mass_awards_elig.derive_rel_operator

672: l_old_operator := null;
673: for loc_ddf_values in c_loc_ddf_values loop
674: l_lei_exists := TRUE;
675: l_new_operator := loc_ddf_values.relational_operator;
676: ghr_mass_awards_elig.derive_rel_operator
677: (p_in_rel_operator => loc_ddf_values.relational_operator,
678: p_out_rel_operator => l_operator,
679: p_prefix => l_pre,
680: p_suffix => l_suf

Line 751: ghr_mass_awards_elig.derive_rel_operator

747: l_old_operator := null;
748: for rating_values in c_rating_values loop
749: l_rating_exists := TRUE;
750: l_new_operator := rating_values.relational_operator;
751: ghr_mass_awards_elig.derive_rel_operator
752: (p_in_rel_operator => rating_values.relational_operator,
753: p_out_rel_operator => l_operator,
754: p_prefix => l_pre,
755: p_suffix => l_suf

Line 1175: End ghr_mass_awards_elig;

1171: p_suffix := NULL;
1172:
1173: End derive_rel_operator;
1174:
1175: End ghr_mass_awards_elig;
1176: