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 932: lv_salary_basis_name per_pay_bases.name%type default null;

928: default null;
929: -- The following defintions were copied from pepaprpo.pkb get_defaults proc
930: lv_currency VARCHAR2(15) default null;
931: lv_format_string VARCHAR2(40) default null;
932: lv_salary_basis_name per_pay_bases.name%type default null;
933: lv_pay_basis_name VARCHAR2(80) default null;
934: lv_pay_basis per_pay_bases.pay_basis%type default null;
935: lv_grade_basis per_pay_bases.rate_basis%type default null;
936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;

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

930: lv_currency VARCHAR2(15) default null;
931: lv_format_string VARCHAR2(40) default null;
932: lv_salary_basis_name per_pay_bases.name%type default null;
933: lv_pay_basis_name VARCHAR2(80) default null;
934: lv_pay_basis per_pay_bases.pay_basis%type default null;
935: lv_grade_basis per_pay_bases.rate_basis%type default null;
936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
937: lv_fte_factor number;
938: lv_grade VARCHAR2(240) default null;

Line 935: lv_grade_basis per_pay_bases.rate_basis%type default null;

931: lv_format_string VARCHAR2(40) default null;
932: lv_salary_basis_name per_pay_bases.name%type default null;
933: lv_pay_basis_name VARCHAR2(80) default null;
934: lv_pay_basis per_pay_bases.pay_basis%type default null;
935: lv_grade_basis per_pay_bases.rate_basis%type default null;
936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
937: lv_fte_factor number;
938: lv_grade VARCHAR2(240) default null;
939: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;

Line 936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;

932: lv_salary_basis_name per_pay_bases.name%type default null;
933: lv_pay_basis_name VARCHAR2(80) default null;
934: lv_pay_basis per_pay_bases.pay_basis%type default null;
935: lv_grade_basis per_pay_bases.rate_basis%type default null;
936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
937: lv_fte_factor number;
938: lv_grade VARCHAR2(240) default null;
939: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;
940: ln_minimum_salary number default null;

Line 939: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;

935: lv_grade_basis per_pay_bases.rate_basis%type default null;
936: lv_pay_annualization_factor per_pay_bases.pay_annualization_factor%type;
937: lv_fte_factor number;
938: lv_grade VARCHAR2(240) default null;
939: lv_grade_annualization_factor per_pay_bases.grade_annualization_factor%type;
940: ln_minimum_salary number default null;
941: ln_maximum_salary number default null;
942: ln_midpoint_salary number default null;
943: ln_prev_salary number default null;

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

961: ld_get_defaults_date date default null;
962: lv_warning_message varchar2(4000) default '';
963: ln_old_pay_annual_factor number default null;
964: ln_old_fte_factor number default null;
965: lv_old_salary_basis_name per_pay_bases.name%type default null;
966: lv_excep_message varchar2(4000) default null;
967: lv_salary_basis_change_type varchar2(30) default 'NEW';
968: ln_payroll_id per_all_assignments_f.payroll_id%type;
969: lb_savepoint_exists boolean default null;

Line 987: ,per_pay_bases ppb

983: ,paf.assignment_type
984: ,ppb.name old_salary_basis_name
985: ,ppb.pay_annualization_factor old_pay_annual_factor
986: FROM per_all_assignments_f paf
987: ,per_pay_bases ppb
988: WHERE assignment_id = p_assignment_id
989: and p_effective_date between effective_start_date
990: and effective_end_date
991: and paf.pay_basis_id = ppb.pay_basis_id(+);

Line 1030: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;

1026: -- Bug 2355929 Fix Ends
1027: ln_job_id number default null;
1028:
1029: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1030: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1031: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

Line 1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;

1028:
1029: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1030: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1031: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1036: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;

1029: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
1030: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1031: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1036: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1037: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;

Line 1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

1030: lv_tmp_salary_basis_name PER_PAY_BASES.NAME%TYPE;
1031: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1036: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1037: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1038: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

Line 1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;

1031: lv_tmp_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
1032: lv_tmp_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
1033: ln_tmp_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
1034: lv_tmp_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
1035: ln_tmp_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
1036: ln_tmp_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
1037: lv_tmp_uom PAY_INPUT_VALUES_F.UOM%TYPE;
1038: lv_tmp_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
1039:

Line 1476: FROM per_pay_bases

1472:
1473: --4002387 start
1474: BEGIN
1475: SELECT pay_basis INTO p_old_pay_basis
1476: FROM per_pay_bases
1477: WHERE pay_basis_id = p_old_pay_basis_id;
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: p_old_pay_basis := '';

Line 1598: FROM PER_ALL_ASSIGNMENTS_F PAF, per_pay_bases ppb

1594: ln_ann_sal number;
1595:
1596: cursor grade_basis is
1597: SELECT ppb.rate_basis
1598: FROM PER_ALL_ASSIGNMENTS_F PAF, per_pay_bases ppb
1599: WHERE PAF.ASSIGNMENT_ID=p_assignment_id
1600: AND p_date BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
1601: and paf.pay_basis_id = ppb.pay_basis_id;
1602:

Line 1607: FROM PER_PAY_BASES PPB

1603: cursor grade_details is
1604: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
1605: , fnd_number.canonical_to_number(PGR.MAXIMUM)
1606: , fnd_number.canonical_to_number(PGR.MID_VALUE)
1607: FROM PER_PAY_BASES PPB
1608: , PAY_GRADE_RULES_F PGR
1609: , PER_ALL_ASSIGNMENTS_F ASG
1610: WHERE ASG.ASSIGNMENT_ID=p_assignment_id
1611: AND PPB.PAY_BASIS_ID=ASG.PAY_BASIS_ID

Line 5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;

5299: uom PAY_INPUT_VALUES_F.UOM%TYPE;
5300: return_mask VARCHAR2(100);
5301:
5302: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5304: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

Line 5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;

5301:
5302: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5304: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5309: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;

Line 5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;

5302: lv_old_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;
5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5304: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5309: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5310: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;

Line 5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;

5303: lv_old_salary_basis_name PER_PAY_BASES.NAME%TYPE;
5304: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5309: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5310: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5311: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;

Line 5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;

5304: lv_old_pay_basis_name HR_LOOKUPS.MEANING%TYPE;
5305: lv_old_pay_basis PER_PAY_BASES.PAY_BASIS%TYPE;
5306: ln_old_pay_annual_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE;
5307: lv_old_grade_basis PER_PAY_BASES.RATE_BASIS%TYPE;
5308: ln_old_grade_annual_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE;
5309: ln_old_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
5310: lv_old_uom PAY_INPUT_VALUES_F.UOM%TYPE;
5311: lv_old_currency_symbol FND_CURRENCIES_VL.SYMBOL%TYPE;
5312: lv_tmp_currency PAY_ELEMENT_TYPES_F.INPUT_CURRENCY_CODE%TYPE;

Line 6555: per_pay_bases pb,

6551: pb.name
6552: from
6553: per_all_assignments_f asf,
6554: per_pay_proposals pay,
6555: per_pay_bases pb,
6556: pay_input_values_f pv
6557: where asf.person_id = p_person_id
6558: and asf.assignment_type = 'O'
6559: and asf.business_group_id = p_bg_id