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 438: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,

434:
435: Function pgm_to_annual1 (p_ref_perd_cd in varchar2,
436: p_pgm_currency in varchar2,
437: p_amount in number,
438: P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
439: P_Effective_Date In Date)
440: RETURN NUMBER is
441: --
442: Cursor csr_cur is

Line 486: from per_all_assignments_f paf

482: l_pay_annualization_factor := to_number(fnd_profile.value('BEN_HRLY_ANAL_FCTR'));
483: If l_pay_annualization_factor is null then
484: -- l_pay_annualization_factor := 2080;
485: select PAY_BASIS_ID into l_pay_basis_id
486: from per_all_assignments_f paf
487: where ASSIGNMENT_ID = P_Assignment_id
488: and P_Effective_Date
489: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
490:

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

515: -- p_status = 4 : GL not using salary update
516: -- p_status = 5 : Assignment not on GL
517: --
518: Procedure get_emp_proposed_salary
519: (P_Assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
520: P_Effective_Date In Date,
521: p_proposed_salary OUT nocopy number,
522: p_sal_chg_dt OUT nocopy date,
523: p_frequency OUT nocopy varchar2,

Line 534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;

530: --
531: L_Cur_Sal Ben_Enrt_Rt.val%type;
532: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
533: --
534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
536: l_person_id Per_All_Assignments_f.person_id%type;
537: l_payroll_id Per_All_Assignments_f.payroll_id%type;
538: --

Line 535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;

531: L_Cur_Sal Ben_Enrt_Rt.val%type;
532: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
533: --
534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
536: l_person_id Per_All_Assignments_f.person_id%type;
537: l_payroll_id Per_All_Assignments_f.payroll_id%type;
538: --
539: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;

Line 536: l_person_id Per_All_Assignments_f.person_id%type;

532: l_update_sal_cd ben_pgm_f.update_salary_cd%type;
533: --
534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
536: l_person_id Per_All_Assignments_f.person_id%type;
537: l_payroll_id Per_All_Assignments_f.payroll_id%type;
538: --
539: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
540: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;

Line 537: l_payroll_id Per_All_Assignments_f.payroll_id%type;

533: --
534: l_pay_basis_id Per_All_Assignments_f.pay_basis_id%type;
535: l_pgm_id Per_All_Assignments_f.GRADE_LADDER_PGM_ID%type;
536: l_person_id Per_All_Assignments_f.person_id%type;
537: l_payroll_id Per_All_Assignments_f.payroll_id%type;
538: --
539: l_pgm_frequency Ben_Pgm_f.ACTY_REF_PERD_CD%type;
540: l_per_in_ler_id Ben_Per_in_Ler.per_in_ler_id%type;
541: --

Line 547: From Per_All_Assignments_f paf

543: l_proc varchar2(72);
544: --
545: Cursor csr_asg_details is
546: Select paf.pay_basis_id, paf.GRADE_LADDER_PGM_ID, paf.person_id
547: From Per_All_Assignments_f paf
548: Where paf.Assignment_Id = p_Assignment_Id
549: and p_Effective_Date
550: Between Paf.Effective_Start_Date and Paf.Effective_End_Date;
551: --