APPS.PQH_GSP_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 316: From per_all_assignments_f assgt

312: -- Check Grade and Grade Ladder is attached to an employee
313: Cursor csr_gl_grade_assg_emp (l_pgm_id Number, l_grade_id Number)
314: IS
315: Select assignment_id
316: From per_all_assignments_f assgt
317: Where grade_id = l_grade_id
318: AND Grade_Ladder_Pgm_Id = l_pgm_id
319: AND p_Effective_Date BETWEEN assgt.effective_start_date
320: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

Line 328: From per_all_assignments_f assgt

324: -- Check Grade is attached to an employee
325: Cursor csr_grd_assg_emp (l_grade_id Number)
326: IS
327: Select Null
328: From per_all_assignments_f assgt
329: Where grade_id = l_grade_id
330: AND p_Effective_Date BETWEEN assgt.effective_start_date
331: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
332: AND assgt.business_group_id = p_Business_Group_Id;

Line 1748: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

1744: ---------------------------Get_Cur_Sal-----------------------------
1745: --
1746:
1747: Function Get_Cur_Sal
1748: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
1749: P_Effective_Date In Date)
1750:
1751: Return Number Is
1752:

Line 1782: Per_All_Assignments_f paf

1778:
1779: Cursor Pay_Bases_Element is
1780: Select input_value_id
1781: From Per_Pay_Bases ppb,
1782: Per_All_Assignments_f paf
1783: Where paf.Assignment_Id = p_Assignment_Id
1784: and p_Effective_Date
1785: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1786: and paf.pay_basis_id = ppb.pay_basis_id;

Line 1791: Per_All_Assignments_f paf

1787:
1788: Cursor GrdLdr_Element is
1789: Select DFLT_INPUT_VALUE_ID
1790: from Ben_Pgm_f pgm,
1791: Per_All_Assignments_f paf
1792: Where paf.Assignment_Id = p_Assignment_Id
1793: and p_Effective_Date
1794: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1795: and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id

Line 2253: From Per_All_Assignments_F

2249:
2250:
2251: Cursor csr_active_gl IS
2252: Select null
2253: From Per_All_Assignments_F
2254: Where Grade_Ladder_Pgm_Id = p_pgm_id
2255: And p_effective_date between effective_start_date
2256: And nvl(effective_end_date, hr_general.end_of_time)
2257: And Business_Group_Id = p_business_group_id;

Line 2806: From per_all_assignments_f assgt

2802: -- Check Grade is attached to an Employee
2803: Cursor csr_gl_grd_emp_assg (l_grade_id Number)
2804: IS
2805: Select Null
2806: From per_all_assignments_f assgt
2807: Where grade_id = l_grade_id
2808: AND Grade_Ladder_Pgm_Id = p_pgm_id
2809: AND p_Effective_Date BETWEEN assgt.effective_start_date
2810: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

Line 2818: From per_all_assignments_f assgt

2814: -- Check Grade is attached to an employee
2815: Cursor csr_grd_assg_emp (l_grade_id Number)
2816: IS
2817: Select Null
2818: From per_all_assignments_f assgt
2819: Where grade_id = l_grade_id
2820: AND p_Effective_Date BETWEEN assgt.effective_start_date
2821: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2822: AND assgt.business_group_id = p_Business_Group_Id;

Line 4121: From Per_All_Assignments_f asg,

4117: and Cur.Currency_Code(+) = Pgm.Pgm_Uom;
4118:
4119: CURSOR C_Pay_Basis IS
4120: select Ppb.Pay_Annualization_Factor,Ppb.Pay_basis
4121: From Per_All_Assignments_f asg,
4122: Per_Pay_Bases ppb
4123: where Asg.Assignment_id = P_Assignment_Id
4124: and P_effective_date
4125: between Asg.Effective_Start_Date