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_PROPOSALS

Line 453: From per_pay_proposals pp, per_assignments_f paf,

449: ln_last_pay2 NUMBER ;
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'

Line 957: ln_pay_proposal_id per_pay_proposals.pay_proposal_id%type ;

953: lv_last_pay_change varchar2(200) default null;
954: lv_flsa_status hr_lookups.meaning%type default null;
955: lv_currency_symbol fnd_currencies.symbol%type default null;
956: ln_precision number default null;
957: ln_pay_proposal_id per_pay_proposals.pay_proposal_id%type ;
958: ln_current_salary number default null;
959: ln_proposal_ovn per_pay_proposals.object_version_number%type;
960: lv_api_mode varchar2(30) default null;
961: ld_get_defaults_date date default null;

Line 959: ln_proposal_ovn per_pay_proposals.object_version_number%type;

955: lv_currency_symbol fnd_currencies.symbol%type default null;
956: ln_precision number default null;
957: ln_pay_proposal_id per_pay_proposals.pay_proposal_id%type ;
958: ln_current_salary number default null;
959: ln_proposal_ovn per_pay_proposals.object_version_number%type;
960: lv_api_mode varchar2(30) 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;

Line 995: -- per_pay_proposals_populate.get_prev_salary procedure.

991: and paf.pay_basis_id = ppb.pay_basis_id(+);
992:
993: -- 05/11/02 - Bug 2340234 Fix Begins
994: -- The following cursor was copied from
995: -- per_pay_proposals_populate.get_prev_salary procedure.
996: CURSOR lc_previous_pay IS
997: SELECT pro.proposed_salary_n
998: ,pro.change_date
999: FROM per_pay_proposals pro

Line 999: FROM per_pay_proposals pro

995: -- per_pay_proposals_populate.get_prev_salary procedure.
996: CURSOR lc_previous_pay IS
997: SELECT pro.proposed_salary_n
998: ,pro.change_date
999: FROM per_pay_proposals pro
1000: WHERE pro.assignment_id = p_assignment_id
1001: AND pro.change_date =(select max(pro2.change_date)
1002: from per_pay_proposals pro2
1003: where pro2.assignment_id = p_assignment_id

Line 1002: from per_pay_proposals pro2

998: ,pro.change_date
999: FROM per_pay_proposals pro
1000: WHERE pro.assignment_id = p_assignment_id
1001: AND pro.change_date =(select max(pro2.change_date)
1002: from per_pay_proposals pro2
1003: where pro2.assignment_id = p_assignment_id
1004: and pro2.change_date < p_effective_date);
1005: -- 05/11/02 - Bug 2340234 Fix Begins
1006:

Line 1013: per_pay_proposals ppp

1009: paf.assignment_type,
1010: ppp.proposed_salary_n
1011: from
1012: per_all_assignments_f paf,
1013: per_pay_proposals ppp
1014: where paf.assignment_id = p_assignment_id
1015: and p_effective_date between paf.effective_start_date and paf.effective_end_date
1016: and ppp.assignment_id = paf.assignment_id
1017: and p_effective_date between ppp.change_date and ppp.date_to;

Line 1086: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => p_effective_date

1082:
1083: ln_old_fte_factor := per_saladmin_utility.get_fte_factor(p_assignment_id,
1084: p_effective_date);
1085:
1086: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => p_effective_date
1087: ,p_assignment_id => p_assignment_id
1088: ,p_currency => lv_tmp_currency
1089: ,p_salary_basis_name => lv_tmp_salary_basis_name
1090: ,p_pay_basis_name => lv_tmp_pay_basis_name

Line 1446: -- per_pay_proposals_populate.get_defaults, that procedure will set prev

1442: THEN
1443: hr_utility.set_location(l_proc,125);
1444: -- If it is a change to a salary basis, we need to derive previous salary
1445: -- again. This is because in my_get_defaults which calls
1446: -- per_pay_proposals_populate.get_defaults, that procedure will set prev
1447: -- salary to null when the old and new salary basis's element type id is
1448: -- different. The Current Pay Rate region will show zero in the Salary
1449: -- and Annual Equivalent columns.
1450: -- This zapping of prev salary to null happens in

Line 1451: -- per_pay_proposals_populate.get_prev_salary procedure.

1447: -- salary to null when the old and new salary basis's element type id is
1448: -- different. The Current Pay Rate region will show zero in the Salary
1449: -- and Annual Equivalent columns.
1450: -- This zapping of prev salary to null happens in
1451: -- per_pay_proposals_populate.get_prev_salary procedure.
1452:
1453: OPEN lc_previous_pay;
1454: FETCH lc_previous_pay into ln_prev_salary2
1455: ,ld_last_change_date;

Line 1462: -- per_pay_proposals_populate.get_prev_salary, it will zap the

1458: IF ln_prev_salary is NULL and ln_prev_salary2 IS NOT NULL
1459: THEN
1460: hr_utility.set_location(l_proc,130);
1461: -- Element type id is changed because in the procedure
1462: -- per_pay_proposals_populate.get_prev_salary, it will zap the
1463: -- previous salary to null if element type id are not equal between
1464: -- the old and new salary basis.
1465: p_element_type_id_changed := 'Y';
1466: ln_prev_salary := ln_prev_salary2;

Line 1621: per_pay_proposals_populate.get_defaults(

1617: AND pgr.effective_end_date;
1618:
1619: BEGIN
1620: hr_utility.set_location(' Entering:' || l_proc,5);
1621: per_pay_proposals_populate.get_defaults(
1622: p_assignment_id => p_assignment_id ,
1623: p_date => p_date,
1624: p_business_group_id => p_business_group_id,
1625: p_currency => p_currency,

Line 2060: from PER_PAY_PROPOSALS

2056: approved,
2057: review_date,
2058: multiple_components,
2059: object_version_number
2060: from PER_PAY_PROPOSALS
2061: Where assignment_id = p_assignment_id
2062: AND business_group_id = p_bg_id
2063: order by change_date desc ;
2064:

Line 2227: from PER_PAY_PROPOSALS

2223: approved,
2224: review_date,
2225: multiple_components,
2226: object_version_number
2227: from PER_PAY_PROPOSALS
2228: Where assignment_id = p_assignment_id
2229: AND business_group_id = p_bg_id
2230: order by change_date desc ;
2231:

Line 2827: from per_pay_proposals

2823: lb_save_point_exists boolean default false;
2824:
2825: cursor csr_payproposal is
2826: select pay_proposal_id, object_version_number
2827: from per_pay_proposals
2828: where assignment_id = p_ltt_salary_data(1).assignment_id
2829: and change_date = ld_effec_date;
2830:
2831: BEGIN

Line 4379: -- per_pay_proposals_populate.get_defaults which will zap the

4375: -- 04/24/02 Change Begins
4376: -- Always reset the previous salary and old annualization factor
4377: -- with the values passed in which were saved at the beginning of the
4378: -- procedure. The reason is that my_get_defaults will call
4379: -- per_pay_proposals_populate.get_defaults which will zap the
4380: -- previous salary to null if element_type_id is different
4381: -- between the old and the new.
4382: ltt_salary_data(1).default_prev_salary := ln_save_prev_salary;
4383: ltt_salary_data(1).default_pay_annual_factor :=ln_save_pay_annual_factor;

Line 5327: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value

5323:
5324: hr_utility.set_location(l_proc,10);
5325: ln_transaction_step_id := p_transaction_step_id;
5326:
5327: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS(p_effective_date => hr_transaction_api.get_date_value
5328: (p_transaction_step_id => ln_transaction_step_id,
5329: p_name => 'p_effective_date')
5330: ,p_assignment_id => hr_transaction_api.get_number_value
5331: (p_transaction_step_id => ln_transaction_step_id,

Line 6396: PER_PAY_PROPOSALS_POPULATE.get_element_id

6392: -- p_effective_date value or the WF effective date.
6393: ld_date := to_date(l_effective_date,
6394: hr_process_assignment_ss.g_date_format);
6395:
6396: PER_PAY_PROPOSALS_POPULATE.get_element_id
6397: (p_assignment_id => ltt_salary_data(1).assignment_id
6398: ,p_business_group_id => ltt_salary_data(1).business_group_id
6399: ,p_change_date => ld_date -- Bug 2360907 Fix
6400: ,p_payroll_value => ln_payroll_id

Line 6554: per_pay_proposals pay,

6550: pay.proposed_salary_n,
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'