APPS.PQH_GSP_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 197: From per_all_assignments_f assgt

193: -- Check Grade and Grade Ladder is attached to an employee
194: Cursor csr_gl_grade_assg_emp (l_pgm_id Number, l_grade_id Number)
195: IS
196: Select assignment_id
197: From per_all_assignments_f assgt
198: Where grade_id = l_grade_id
199: AND Grade_Ladder_Pgm_Id = l_pgm_id
200: AND p_Effective_Date BETWEEN assgt.effective_start_date
201: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

Line 209: From per_all_assignments_f assgt

205: -- Check Grade is attached to an employee
206: Cursor csr_grd_assg_emp (l_grade_id Number)
207: IS
208: Select Null
209: From per_all_assignments_f assgt
210: Where grade_id = l_grade_id
211: AND p_Effective_Date BETWEEN assgt.effective_start_date
212: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
213: AND assgt.business_group_id = p_Business_Group_Id;

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

1625: ---------------------------Get_Cur_Sal-----------------------------
1626: --
1627:
1628: Function Get_Cur_Sal
1629: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
1630: P_Effective_Date In Date)
1631:
1632: Return Number Is
1633:

Line 1663: Per_All_Assignments_f paf

1659:
1660: Cursor Pay_Bases_Element is
1661: Select input_value_id
1662: From Per_Pay_Bases ppb,
1663: Per_All_Assignments_f paf
1664: Where paf.Assignment_Id = p_Assignment_Id
1665: and p_Effective_Date
1666: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1667: and paf.pay_basis_id = ppb.pay_basis_id;

Line 1672: Per_All_Assignments_f paf

1668:
1669: Cursor GrdLdr_Element is
1670: Select DFLT_INPUT_VALUE_ID
1671: from Ben_Pgm_f pgm,
1672: Per_All_Assignments_f paf
1673: Where paf.Assignment_Id = p_Assignment_Id
1674: and p_Effective_Date
1675: Between Paf.Effective_Start_Date and Paf.Effective_End_Date
1676: and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id

Line 2134: From Per_All_Assignments_F

2130:
2131:
2132: Cursor csr_active_gl IS
2133: Select null
2134: From Per_All_Assignments_F
2135: Where Grade_Ladder_Pgm_Id = p_pgm_id
2136: And p_effective_date between effective_start_date
2137: And nvl(effective_end_date, hr_general.end_of_time)
2138: And Business_Group_Id = p_business_group_id;

Line 2687: From per_all_assignments_f assgt

2683: -- Check Grade is attached to an Employee
2684: Cursor csr_gl_grd_emp_assg (l_grade_id Number)
2685: IS
2686: Select Null
2687: From per_all_assignments_f assgt
2688: Where grade_id = l_grade_id
2689: AND Grade_Ladder_Pgm_Id = p_pgm_id
2690: AND p_Effective_Date BETWEEN assgt.effective_start_date
2691: AND nvl(assgt.effective_end_date,hr_general.end_of_time)

Line 2699: From per_all_assignments_f assgt

2695: -- Check Grade is attached to an employee
2696: Cursor csr_grd_assg_emp (l_grade_id Number)
2697: IS
2698: Select Null
2699: From per_all_assignments_f assgt
2700: Where grade_id = l_grade_id
2701: AND p_Effective_Date BETWEEN assgt.effective_start_date
2702: AND nvl(assgt.effective_end_date,hr_general.end_of_time)
2703: AND assgt.business_group_id = p_Business_Group_Id;

Line 4002: From Per_All_Assignments_f asg,

3998: and Cur.Currency_Code(+) = Pgm.Pgm_Uom;
3999:
4000: CURSOR C_Pay_Basis IS
4001: select Ppb.Pay_Annualization_Factor,Ppb.Pay_basis
4002: From Per_All_Assignments_f asg,
4003: Per_Pay_Bases ppb
4004: where Asg.Assignment_id = P_Assignment_Id
4005: and P_effective_date
4006: between Asg.Effective_Start_Date