APPS.PQH_GSP_DEFAULT dependencies on PER_ALL_ASSIGNMENTS_F

Line 9: from ben_per_in_ler pil,per_all_assignments_f asg

5: l_assignment_id number;
6: begin
7: select asg.assignment_id
8: into l_assignment_id
9: from ben_per_in_ler pil,per_all_assignments_f asg
10: where p_effective_date between asg.effective_start_date and asg.effective_end_date
11: and pil.per_in_ler_id = p_per_in_ler_id
12: and pil.person_id = asg.person_id
13: and asg.assignment_type = 'E'

Line 33: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;

29: L_PIL_OVN NUMBER;
30: l_procd_dt date;
31: l_strtd_dt date;
32: l_voidd_dt date;
33: l_Assignment_id Per_All_Assignments_F.Assignment_Id%TYPE;
34: l_legislation_code per_business_groups.legislation_code%type;
35: l_return_status varchar2(1);
36:
37: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

Line 464: from per_all_assignments_f

460: p_future_step_id out nocopy number) is
461: l_asg_check_date date;
462: cursor csr_asgs is
463: select grade_id
464: from per_all_assignments_f
465: where assignment_id = p_assignment_id
466: and l_asg_check_date between effective_start_date and effective_end_date;
467: cursor csr_spps is
468: select step_id

Line 758: from per_all_assignments_f

754: l_assignment_id number;
755: cursor csr_asg_rec is
756: select effective_start_date,effective_end_date,grade_ladder_pgm_id,grade_id,
757: special_ceiling_step_id,business_group_id
758: from per_all_assignments_f
759: where assignment_id = l_assignment_id
760: and p_effective_date between effective_start_date and effective_end_date;
761: l_asg_esd date;
762: l_asg_eed date;

Line 1074: Per_All_Assignments_f paf

1070: and pev.Input_Value_id = l_input_value_id;
1071: Cursor Pay_Bases_Element is
1072: Select input_value_id
1073: From Per_Pay_Bases ppb,
1074: Per_All_Assignments_f paf
1075: Where paf.Assignment_Id = p_Assignment_Id
1076: and p_Effective_Date Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1077: and paf.pay_basis_id = ppb.pay_basis_id;
1078: Cursor GrdLdr_Element is

Line 1081: Per_All_Assignments_f paf

1077: and paf.pay_basis_id = ppb.pay_basis_id;
1078: Cursor GrdLdr_Element is
1079: Select DFLT_INPUT_VALUE_ID
1080: from Ben_Pgm_f pgm,
1081: Per_All_Assignments_f paf
1082: Where paf.Assignment_Id = p_Assignment_Id
1083: and p_Effective_Date
1084: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1085: and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id

Line 1206: from Per_all_Assignments_F Asgt,

1202: l_next_sal number;
1203:
1204: Cursor Csr_Step is
1205: Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id
1206: from Per_all_Assignments_F Asgt,
1207: Ben_Per_In_Ler Pler,
1208: Ben_Ler_F Ler,
1209: Ben_Elig_Per_Elctbl_Chc ELctbl,
1210: Ben_Enrt_Rt Rt

Line 1269: Per_All_Assignments_f paf

1265:
1266: Cursor Pay_Bases_Element is
1267: Select input_value_id,pay_annualization_factor
1268: From Per_Pay_Bases ppb,
1269: Per_All_Assignments_f paf
1270: Where paf.Assignment_Id = p_Assignment_Id
1271: and p_Effective_Date Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1272: and paf.pay_basis_id = ppb.pay_basis_id;
1273:

Line 1277: Per_All_Assignments_f paf

1273:
1274: Cursor GrdLdr_Element is
1275: Select DFLT_INPUT_VALUE_ID
1276: from Ben_Pgm_f pgm,
1277: Per_All_Assignments_f paf
1278: Where paf.Assignment_Id = p_Assignment_Id
1279: and p_Effective_Date
1280: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1281: and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id