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.PER_SALADMIN_UTILITY dependencies on PER_PAY_PROPOSALS

Line 160: (p_change_date in per_pay_proposals.change_date%TYPE

156:
157:
158:
159: function derive_next_sal_perf_date
160: (p_change_date in per_pay_proposals.change_date%TYPE
161: ,p_period in per_all_assignments_f.sal_review_period%TYPE
162: ,p_frequency in per_all_assignments_f.sal_review_period_frequency%TYPE
163: )
164: Return Date is

Line 246: per_pay_proposals ppp

242: FROM pay_element_types_f pet,
243: per_all_assignments_f paaf,
244: pay_input_values_f piv,
245: per_pay_bases ppb,
246: per_pay_proposals ppp
247: WHERE ppp.pay_proposal_id = p_pay_proposal_id
248: and paaf.assignment_id = ppp.assignment_id
249: and ppp.change_date BETWEEN paaf.effective_start_date
250: and paaf.effective_end_date

Line 271: from per_pay_proposals pro

267: is
268: l_prev_change_date date;
269: CURSOR c_prev_pay_proposals is
270: select max(change_date)
271: from per_pay_proposals pro
272: where pro.assignment_id = p_assignment_id
273: and pro.change_date < p_change_date ;
274: begin
275: OPEN c_prev_pay_proposals;

Line 295: from per_pay_proposals

291: is
292: cursor c1(p_assignment_id in number,
293: p_session_date in date) is
294: select change_date
295: from per_pay_proposals
296: where assignment_id = p_assignment_id
297: and multiple_components = 'Y'
298: and change_date =
299: (select min(change_date)

Line 300: from per_pay_proposals

296: where assignment_id = p_assignment_id
297: and multiple_components = 'Y'
298: and change_date =
299: (select min(change_date)
300: from per_pay_proposals
301: where assignment_id = p_assignment_id
302: and change_date > p_session_date);
303: --
304: l_change_date per_pay_proposals.change_date%TYPE;

Line 304: l_change_date per_pay_proposals.change_date%TYPE;

300: from per_pay_proposals
301: where assignment_id = p_assignment_id
302: and change_date > p_session_date);
303: --
304: l_change_date per_pay_proposals.change_date%TYPE;
305: begin
306: --
307: open c1(p_assignment_id, p_session_date);
308: fetch c1 into l_change_date;

Line 322: l_next_change_date per_pay_proposals.change_date%TYPE;

318: (
319: p_assignment_id number
320: ) is
321:
322: l_next_change_date per_pay_proposals.change_date%TYPE;
323: l_approved per_pay_proposals.approved%TYPE;
324: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
325:
326: Cursor csr_pay_proposals

Line 323: l_approved per_pay_proposals.approved%TYPE;

319: p_assignment_id number
320: ) is
321:
322: l_next_change_date per_pay_proposals.change_date%TYPE;
323: l_approved per_pay_proposals.approved%TYPE;
324: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
325:
326: Cursor csr_pay_proposals
327: is

Line 329: from per_pay_proposals

325:
326: Cursor csr_pay_proposals
327: is
328: select pay_proposal_id, change_date,date_to
329: from per_pay_proposals
330: where assignment_id = p_assignment_id
331: and approved = 'Y';
332:
333: Cursor csr_next_change_date(p_change_date in date)

Line 336: from per_pay_proposals

332:
333: Cursor csr_next_change_date(p_change_date in date)
334: IS
335: select min(change_date)
336: from per_pay_proposals
337: where change_date > p_change_date
338: and assignment_id = p_assignment_id;
339:
340: Cursor csr_approved(p_change_date in date)

Line 343: from per_pay_proposals

339:
340: Cursor csr_approved(p_change_date in date)
341: is
342: select approved
343: from per_pay_proposals
344: where change_date = p_change_date
345: and assignment_id = p_assignment_id;
346:
347: Cursor element_entry_end_date(p_pay_proposal_id in number,p_change_date in date)

Line 409: update per_pay_proposals

405: if g_debug then
406: hr_utility.set_location('About to update', 70);
407: end if;
408:
409: update per_pay_proposals
410: set date_to =l_element_entry_end_date
411: where pay_proposal_id = i.pay_proposal_id;
412:
413: if g_debug then

Line 457: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

453:
454: Function get_previous_salary(p_assignment_id IN NUMBER,p_proposal_id in number)
455: return number
456: is
457: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
458: CURSOR previous_pay is
459: select pro.proposed_salary_n
460: from per_pay_proposals pro
461: where pro.assignment_id = p_assignment_id

Line 460: from per_pay_proposals pro

456: is
457: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
458: CURSOR previous_pay is
459: select pro.proposed_salary_n
460: from per_pay_proposals pro
461: where pro.assignment_id = p_assignment_id
462: and pro.change_date =(select max(pro2.change_date)
463: from per_pay_proposals pro2
464: where pro2.assignment_id = p_assignment_id

Line 463: from per_pay_proposals pro2

459: select pro.proposed_salary_n
460: from per_pay_proposals pro
461: where pro.assignment_id = p_assignment_id
462: and pro.change_date =(select max(pro2.change_date)
463: from per_pay_proposals pro2
464: where pro2.assignment_id = p_assignment_id
465: and pro2.change_date < (select change_date from per_pay_proposals
466: where pay_proposal_id =p_proposal_id));
467: begin

Line 465: and pro2.change_date < (select change_date from per_pay_proposals

461: where pro.assignment_id = p_assignment_id
462: and pro.change_date =(select max(pro2.change_date)
463: from per_pay_proposals pro2
464: where pro2.assignment_id = p_assignment_id
465: and pro2.change_date < (select change_date from per_pay_proposals
466: where pay_proposal_id =p_proposal_id));
467: begin
468: OPEN previous_pay;
469: FETCH previous_pay into l_previous_salary;

Line 483: l_salary per_pay_proposals.proposed_salary_n%TYPE;

479:
480: FUNCTION get_proposed_salary (p_assignment_id IN NUMBER,p_effective_date IN DATE )
481: RETURN NUMBER
482: is
483: l_salary per_pay_proposals.proposed_salary_n%TYPE;
484:
485: cursor csr_sal is
486: select proposed_salary_n
487: from per_pay_proposals

Line 487: from per_pay_proposals

483: l_salary per_pay_proposals.proposed_salary_n%TYPE;
484:
485: cursor csr_sal is
486: select proposed_salary_n
487: from per_pay_proposals
488: where assignment_id = p_assignment_id
489: and p_effective_date between nvl(change_date,hr_general.start_of_time) and nvl(date_to,hr_general.end_of_time);
490: begin
491: open csr_sal;

Line 695: PER_PAY_PROPOSALS_POPULATE.GET_PAYROLL(p_assignment_id

691: l_annualization_factor NUMBER(20);
692: Begin
693: l_annualization_factor := p_annualization_factor;
694: if(p_pay_basis ='PERIOD' and l_annualization_factor is null) then
695: PER_PAY_PROPOSALS_POPULATE.GET_PAYROLL(p_assignment_id
696: ,p_effective_date
697: ,l_dummy
698: ,l_annualization_factor);
699: end if;

Line 932: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

928: p_proposal_id IN NUMBER,
929: p_proposed_salary in number)
930: RETURN NUMBER
931: IS
932: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
933: BEGIN
934: l_previous_salary:= get_previous_salary(p_assignment_id,p_proposal_id);
935: if l_previous_salary = -1 then
936: return p_proposed_salary;

Line 948: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

944: p_proposed_salary in number)
945: RETURN NUMBER
946: is
947: l_change_amount number;
948: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
949:
950: BEGIN
951: l_change_amount:= get_change_amount (p_assignment_id ,p_proposal_id ,p_proposed_salary);
952: l_previous_salary :=get_previous_salary(p_assignment_id,p_proposal_id);

Line 1028: l_rec per_pay_proposals%ROWTYPE;

1024: l_new_pay_annual_factor NUMBER;
1025: l_new_currency VARCHAR2(15);
1026: l_new_annual_salary NUMBER;
1027: l_new_uom VARCHAR2(15);
1028: l_rec per_pay_proposals%ROWTYPE;
1029: --
1030: -- Cursor to get the pay proposal details
1031: --
1032: cursor get_prop_det (c_assignment_id in number,c_pay_basis_id in number) is

Line 1033: select * from per_pay_proposals pro

1029: --
1030: -- Cursor to get the pay proposal details
1031: --
1032: cursor get_prop_det (c_assignment_id in number,c_pay_basis_id in number) is
1033: select * from per_pay_proposals pro
1034: where pro.assignment_id = c_assignment_id
1035: and (p_effective_date - 1) between change_date and nvl(date_to,to_date('31/12/4712','dd/mm/yyyy'));
1036: -- and pro.pay_proposal_id = c_pay_basis_id;
1037: --

Line 1092: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

1088: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1089: --
1090: --Calculate the currency and pay_annualization_factor of the old salary basis
1091: --
1092: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1093: (p_effective_date => l_prev_change_date
1094: ,p_assignment_id => p_assignment_id
1095: ,p_currency => l_old_currency
1096: ,p_salary_basis_name => l_salary_basis_name

Line 1138: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

1134: end if;
1135: --
1136: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1137: /**
1138: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1139: (p_effective_date => p_effective_date
1140: ,p_assignment_id => p_assignment_id
1141: ,p_currency => l_new_currency
1142: ,p_salary_basis_name => l_salary_basis_name

Line 1387: PER_PAY_PROPOSALS_POPULATE.get_asg_hours(p_assignment_id

1383: BEGIN
1384: --
1385: if (l_fte_profile_value = 'NHBGWH') then
1386:
1387: PER_PAY_PROPOSALS_POPULATE.get_asg_hours(p_assignment_id
1388: ,p_effective_date
1389: ,l_hours_per_year);
1390:
1391: if(nvl(l_hours_per_year,0) <> 0) then

Line 1392: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id

1388: ,p_effective_date
1389: ,l_hours_per_year);
1390:
1391: if(nvl(l_hours_per_year,0) <> 0) then
1392: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id
1393: ,p_effective_date
1394: ,l_norm_hours_per_year);
1395: if ( nvl(l_norm_hours_per_year,0) = 0) then
1396: l_fte_factor := 1;

Line 1429: from per_pay_proposals pro

1425: return varchar2 is
1426: l_dummy varchar2(10);
1427: CURSOR c_pay_proposals is
1428: select null
1429: from per_pay_proposals pro
1430: where pro.assignment_id = p_assignment_id
1431: and pro.change_date = p_date;
1432: begin
1433: OPEN c_pay_proposals;

Line 1448: from per_pay_proposals pro

1444: return date is
1445: l_min_change_date date;
1446: CURSOR c_pay_proposals is
1447: select min(change_date)
1448: from per_pay_proposals pro
1449: where pro.assignment_id = p_assignment_id;
1450: begin
1451: OPEN c_pay_proposals;
1452: FETCH c_pay_proposals into l_min_change_date;