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_GSP_DEFAULT dependencies on PER_PAY_BASES

Line 1073: From Per_Pay_Bases ppb,

1069: and p_Effective_Date between pee.Effective_Start_Date and pee.Effective_End_Date
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;

Line 1253: l_annualization_factor Per_pay_bases.pay_annualization_factor%TYPE;

1249: p_effective_date in date) return number Is
1250:
1251: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1252: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
1253: l_annualization_factor Per_pay_bases.pay_annualization_factor%TYPE;
1254: L_Payroll_name pay_all_payrolls_f.Payroll_name%TYPE;
1255:
1256: Cursor Sal is
1257: select pev.screen_entry_value*l_annualization_factor

Line 1268: From Per_Pay_Bases ppb,

1264: and pev.Input_Value_id = l_input_value_id;
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;