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.HR_PAY_RATE_SS dependencies on PER_PAY_BASES

Line 39: per_pay_bases pb, pay_input_values_f ivf

35:
36: Cursor c1 (p_aid number, p_date date) IS
37: select ivf.element_type_id
38: from per_all_assignments_f paf,
39: per_pay_bases pb, pay_input_values_f ivf
40: where paf.assignment_id = p_aid
41: --and paf.assignment_type = 'E'
42: and pb.pay_basis_id = paf.pay_basis_id
43: and pb.input_value_id = ivf.input_value_id

Line 454: per_pay_bases ppb

450:
451: CURSOR c_last_pay IS
452: Select pp.proposed_salary_n*pay_annualization_factor
453: From per_pay_proposals pp, per_assignments_f paf,
454: per_pay_bases ppb
455: Where pp.assignment_id = p_assignment_id
456: And pp.business_group_id = p_bus_group_id
457: And pp.approved = 'Y'
458: And pp.assignment_id = paf.assignment_id

Line 927: lv_salary_basis_name per_pay_bases.name%type default null;

923: default null;
924: -- The following defintions were copied from pepaprpo.pkb get_defaults proc
925: lv_currency VARCHAR2(15) default null;
926: lv_format_string VARCHAR2(40) default null;
927: lv_salary_basis_name per_pay_bases.name%type default null;
928: lv_pay_basis_name VARCHAR2(80) default null;
929: lv_pay_basis per_pay_bases.pay_basis%type default null;
930: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
931: lv_grade VARCHAR2(240) default null;

Line 929: lv_pay_basis per_pay_bases.pay_basis%type default null;

925: lv_currency VARCHAR2(15) default null;
926: lv_format_string VARCHAR2(40) default null;
927: lv_salary_basis_name per_pay_bases.name%type default null;
928: lv_pay_basis_name VARCHAR2(80) default null;
929: lv_pay_basis per_pay_bases.pay_basis%type default null;
930: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
931: lv_grade VARCHAR2(240) default null;
932: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;
933: ln_minimum_salary number default null;

Line 930: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;

926: lv_format_string VARCHAR2(40) default null;
927: lv_salary_basis_name per_pay_bases.name%type default null;
928: lv_pay_basis_name VARCHAR2(80) default null;
929: lv_pay_basis per_pay_bases.pay_basis%type default null;
930: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
931: lv_grade VARCHAR2(240) default null;
932: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;
933: ln_minimum_salary number default null;
934: ln_maximum_salary number default null;

Line 932: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;

928: lv_pay_basis_name VARCHAR2(80) default null;
929: lv_pay_basis per_pay_bases.pay_basis%type default null;
930: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
931: lv_grade VARCHAR2(240) default null;
932: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;
933: ln_minimum_salary number default null;
934: ln_maximum_salary number default null;
935: ln_midpoint_salary number default null;
936: ln_prev_salary number default null;

Line 957: lv_old_salary_basis_name per_pay_bases.name%type default null;

953: lv_api_mode varchar2(30) default null;
954: ld_get_defaults_date date default null;
955: lv_warning_message varchar2(4000) default '';
956: ln_old_pay_annual_factor number default null;
957: lv_old_salary_basis_name per_pay_bases.name%type default null;
958: lv_excep_message varchar2(4000) default null;
959: lv_salary_basis_change_type varchar2(30) default 'NEW';
960: ln_payroll_id per_all_assignments_f.payroll_id%type;
961: lb_savepoint_exists boolean default null;

Line 979: ,per_pay_bases ppb

975: ,paf.assignment_type
976: ,ppb.name old_salary_basis_name
977: ,ppb.pay_annualization_factor old_pay_annual_factor
978: FROM per_all_assignments_f paf
979: ,per_pay_bases ppb
980: WHERE assignment_id = p_assignment_id
981: and p_effective_date between effective_start_date
982: and effective_end_date
983: and paf.pay_basis_id = ppb.pay_basis_id(+);

Line 1007: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;

1003: -- Bug 2355929 Fix Ends
1004: ln_job_id number default null;
1005:
1006: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1007: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1008: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

Line 1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;

1005:
1006: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1007: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1008: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1013: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;

1006: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1007: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1008: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1013: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1014: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;

Line 1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

1007: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1008: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1013: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1014: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1015: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

Line 1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;

1008: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1009: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1010: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1011: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1012: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1013: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1014: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1015: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
1016:

Line 1429: FROM per_pay_bases

1425:
1426: --4002387 start
1427: BEGIN
1428: SELECT pay_basis INTO p_old_pay_basis
1429: FROM per_pay_bases
1430: WHERE pay_basis_id = p_old_pay_basis_id;
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: p_old_pay_basis := '';

Line 5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;

5138: uom PAY_INPUT_VALUES_F.UOM%TYPE;
5139: return_mask VARCHAR2(100);
5140:
5141: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5143: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

Line 5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;

5140:
5141: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5143: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5148: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;

5141: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5143: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5148: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5149: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;

Line 5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

5142: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5143: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5148: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5149: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5150: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

Line 5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;

5143: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5144: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5145: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5146: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5147: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5148: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5149: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5150: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
5151: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;

Line 6253: per_pay_bases pb,

6249: pb.name
6250: from
6251: per_all_assignments_f asf,
6252: per_pay_proposals pay,
6253: per_pay_bases pb,
6254: pay_input_values_f pv
6255: where asf.person_id = p_person_id
6256: and asf.assignment_type = 'O'
6257: and asf.business_group_id = p_bg_id