eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_EMPLOYEE_SALARY dependencies on PER_ALL_ASSIGNMENTS_F

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

11: p_pay_basis = 'N' : Salary determined from Grade Ladder element
12: ****/
13:
14: Procedure get_employee_salary
15: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
16: P_Effective_Date In Date,
17: p_salary OUT nocopy number,
18: p_frequency OUT nocopy varchar2,
19: p_annual_salary OUT nocopy number,

Line 30: l_business_group_id Per_All_Assignments_f.business_group_id%type;

26: --
27: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;

Line 32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;

28: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;
35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
36: l_precision Fnd_Currencies.Precision%type;

Line 33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;

29: l_dummy_iv_id pay_input_values_f.Input_Value_id%TYPE;
30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;
35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
36: l_precision Fnd_Currencies.Precision%type;
37: L_Salary pay_element_entry_values_f.screen_entry_value%TYPE;

Line 34: l_payroll_id Per_All_Assignments_f.payroll_id%type;

30: l_business_group_id Per_All_Assignments_f.business_group_id%type;
31: --
32: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
33: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
34: l_payroll_id Per_All_Assignments_f.payroll_id%type;
35: l_basis_Annl_fctr Per_Pay_Bases.Pay_Annualization_Factor%TYPE;
36: l_precision Fnd_Currencies.Precision%type;
37: L_Salary pay_element_entry_values_f.screen_entry_value%TYPE;
38: --

Line 44: From Per_All_Assignments_f paf

40: l_proc varchar2(72);
41: --
42: Cursor csr_asg_details is
43: Select paf.pay_basis_id, paf.GRADE_LADDER_PGM_ID, paf.payroll_id,paf.business_group_id
44: From Per_All_Assignments_f paf
45: Where paf.Assignment_Id = p_Assignment_Id
46: and p_Effective_Date
47: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
48: --

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

437: -- p_status = 4 : GL not using salary update
438: -- p_status = 5 : Assignment not on GL
439: --
440: Procedure get_emp_proposed_salary
441: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
442: P_Effective_Date In Date,
443: p_proposed_salary OUT nocopy number,
444: p_sal_chg_dt OUT nocopy date,
445: p_frequency OUT nocopy varchar2,

Line 456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;

452: --
453: L_Cur_Sal Ben_Enrt_Rt.val%type;
454: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
455: --
456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
458: l_person_id Per_All_Assignments_f.person_id%type;
459: l_payroll_id Per_All_Assignments_f.payroll_id%type;
460: --

Line 457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;

453: L_Cur_Sal Ben_Enrt_Rt.val%type;
454: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
455: --
456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
458: l_person_id Per_All_Assignments_f.person_id%type;
459: l_payroll_id Per_All_Assignments_f.payroll_id%type;
460: --
461: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;

Line 458: l_person_id Per_All_Assignments_f.person_id%type;

454: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
455: --
456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
458: l_person_id Per_All_Assignments_f.person_id%type;
459: l_payroll_id Per_All_Assignments_f.payroll_id%type;
460: --
461: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
462: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;

Line 459: l_payroll_id Per_All_Assignments_f.payroll_id%type;

455: --
456: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
457: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
458: l_person_id Per_All_Assignments_f.person_id%type;
459: l_payroll_id Per_All_Assignments_f.payroll_id%type;
460: --
461: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
462: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;
463: --

Line 469: From Per_All_Assignments_f paf

465: l_proc varchar2(72);
466: --
467: Cursor csr_asg_details is
468: Select paf.pay_basis_id, paf.GRADE_LADDER_PGM_ID, paf.person_id
469: From Per_All_Assignments_f paf
470: Where paf.Assignment_Id = p_Assignment_Id
471: and p_Effective_Date
472: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
473: --