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 250: per_pay_proposals ppp

246: FROM pay_element_types_f pet,
247: per_all_assignments_f paaf,
248: pay_input_values_f piv,
249: per_pay_bases ppb,
250: per_pay_proposals ppp
251: WHERE ppp.pay_proposal_id = p_pay_proposal_id
252: and paaf.assignment_id = ppp.assignment_id
253: and ppp.change_date BETWEEN paaf.effective_start_date
254: and paaf.effective_end_date

Line 275: from per_pay_proposals pro

271: is
272: l_prev_change_date date;
273: CURSOR c_prev_pay_proposals is
274: select max(change_date)
275: from per_pay_proposals pro
276: where pro.assignment_id = p_assignment_id
277: and pro.change_date < p_change_date ;
278: begin
279: OPEN c_prev_pay_proposals;

Line 299: from per_pay_proposals

295: is
296: cursor c1(p_assignment_id in number,
297: p_session_date in date) is
298: select change_date
299: from per_pay_proposals
300: where assignment_id = p_assignment_id
301: and multiple_components = 'Y'
302: and change_date =
303: (select min(change_date)

Line 304: from per_pay_proposals

300: where assignment_id = p_assignment_id
301: and multiple_components = 'Y'
302: and change_date =
303: (select min(change_date)
304: from per_pay_proposals
305: where assignment_id = p_assignment_id
306: and change_date > p_session_date);
307: --
308: l_change_date per_pay_proposals.change_date%TYPE;

Line 308: l_change_date per_pay_proposals.change_date%TYPE;

304: from per_pay_proposals
305: where assignment_id = p_assignment_id
306: and change_date > p_session_date);
307: --
308: l_change_date per_pay_proposals.change_date%TYPE;
309: begin
310: --
311: open c1(p_assignment_id, p_session_date);
312: fetch c1 into l_change_date;

Line 326: l_next_change_date per_pay_proposals.change_date%TYPE;

322: (
323: p_assignment_id number
324: ) is
325:
326: l_next_change_date per_pay_proposals.change_date%TYPE;
327: l_approved per_pay_proposals.approved%TYPE;
328: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
329:
330: Cursor csr_pay_proposals

Line 327: l_approved per_pay_proposals.approved%TYPE;

323: p_assignment_id number
324: ) is
325:
326: l_next_change_date per_pay_proposals.change_date%TYPE;
327: l_approved per_pay_proposals.approved%TYPE;
328: l_element_entry_end_date pay_element_entries_f.effective_end_date%TYPE;
329:
330: Cursor csr_pay_proposals
331: is

Line 333: from per_pay_proposals

329:
330: Cursor csr_pay_proposals
331: is
332: select pay_proposal_id, change_date,date_to
333: from per_pay_proposals
334: where assignment_id = p_assignment_id
335: and approved = 'Y';
336:
337: Cursor csr_next_change_date(p_change_date in date)

Line 340: from per_pay_proposals

336:
337: Cursor csr_next_change_date(p_change_date in date)
338: IS
339: select min(change_date)
340: from per_pay_proposals
341: where change_date > p_change_date
342: and assignment_id = p_assignment_id;
343:
344: Cursor csr_approved(p_change_date in date)

Line 347: from per_pay_proposals

343:
344: Cursor csr_approved(p_change_date in date)
345: is
346: select approved
347: from per_pay_proposals
348: where change_date = p_change_date
349: and assignment_id = p_assignment_id;
350:
351: Cursor element_entry_end_date(p_pay_proposal_id in number,p_change_date in date)

Line 413: update per_pay_proposals

409: if g_debug then
410: hr_utility.set_location('About to update', 70);
411: end if;
412:
413: update per_pay_proposals
414: set date_to =l_element_entry_end_date
415: where pay_proposal_id = i.pay_proposal_id;
416:
417: if g_debug then

Line 488: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

484:
485: Function get_previous_salary(p_assignment_id IN NUMBER,p_proposal_id in number)
486: return number
487: is
488: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
489: CURSOR previous_pay is
490: select pro.proposed_salary_n
491: from per_pay_proposals pro
492: where pro.assignment_id = p_assignment_id

Line 491: from per_pay_proposals pro

487: is
488: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
489: CURSOR previous_pay is
490: select pro.proposed_salary_n
491: from per_pay_proposals pro
492: where pro.assignment_id = p_assignment_id
493: and pro.change_date =(select max(pro2.change_date)
494: from per_pay_proposals pro2
495: where pro2.assignment_id = p_assignment_id

Line 494: from per_pay_proposals pro2

490: select pro.proposed_salary_n
491: from per_pay_proposals pro
492: where pro.assignment_id = p_assignment_id
493: and pro.change_date =(select max(pro2.change_date)
494: from per_pay_proposals pro2
495: where pro2.assignment_id = p_assignment_id
496: and pro2.change_date < (select change_date from per_pay_proposals
497: where pay_proposal_id =p_proposal_id));
498: begin

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

492: where pro.assignment_id = p_assignment_id
493: and pro.change_date =(select max(pro2.change_date)
494: from per_pay_proposals pro2
495: where pro2.assignment_id = p_assignment_id
496: and pro2.change_date < (select change_date from per_pay_proposals
497: where pay_proposal_id =p_proposal_id));
498: begin
499: OPEN previous_pay;
500: FETCH previous_pay into l_previous_salary;

Line 514: l_salary per_pay_proposals.proposed_salary_n%TYPE;

510:
511: FUNCTION get_proposed_salary (p_assignment_id IN NUMBER,p_effective_date IN DATE )
512: RETURN NUMBER
513: is
514: l_salary per_pay_proposals.proposed_salary_n%TYPE;
515:
516: cursor csr_sal is
517: select proposed_salary_n
518: from per_pay_proposals

Line 518: from per_pay_proposals

514: l_salary per_pay_proposals.proposed_salary_n%TYPE;
515:
516: cursor csr_sal is
517: select proposed_salary_n
518: from per_pay_proposals
519: where assignment_id = p_assignment_id
520: and p_effective_date between nvl(change_date,hr_general.start_of_time) and nvl(date_to,hr_general.end_of_time);
521: begin
522: open csr_sal;

Line 726: PER_PAY_PROPOSALS_POPULATE.GET_PAYROLL(p_assignment_id

722: l_annualization_factor NUMBER(20);
723: Begin
724: l_annualization_factor := p_annualization_factor;
725: if(p_pay_basis ='PERIOD' and l_annualization_factor is null) then
726: PER_PAY_PROPOSALS_POPULATE.GET_PAYROLL(p_assignment_id
727: ,p_effective_date
728: ,l_dummy
729: ,l_annualization_factor);
730: end if;

Line 963: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

959: p_proposal_id IN NUMBER,
960: p_proposed_salary in number)
961: RETURN NUMBER
962: IS
963: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
964: BEGIN
965: l_previous_salary:= get_previous_salary(p_assignment_id,p_proposal_id);
966: if l_previous_salary = -1 then
967: return p_proposed_salary;

Line 979: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;

975: p_proposed_salary in number)
976: RETURN NUMBER
977: is
978: l_change_amount number;
979: l_previous_salary per_pay_proposals.proposed_salary_n%TYPE;
980:
981: BEGIN
982: l_change_amount:= get_change_amount (p_assignment_id ,p_proposal_id ,p_proposed_salary);
983: l_previous_salary :=get_previous_salary(p_assignment_id,p_proposal_id);

Line 1027: l_proposal_rec per_pay_proposals%ROWTYPE;

1023: p_effective_date in date)
1024: is
1025:
1026: l_creator_id number;
1027: l_proposal_rec per_pay_proposals%ROWTYPE;
1028: l_date_to date;
1029:
1030: l_component_id per_pay_proposal_components.component_id%TYPE;
1031: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

Line 1053: select * from per_pay_proposals

1049: and effective_start_date=p_effective_date
1050: and creator_type='SP';
1051:
1052: cursor csr_pay_proposal(c_assignment_id in number,c_pay_proposal_id in number) is
1053: select * from per_pay_proposals
1054: where ASSIGNMENT_ID=c_assignment_id
1055: and pay_proposal_id=c_pay_proposal_id;
1056:
1057: cursor csr_proposal_components(c_pay_proposal_id in number) is

Line 1253: l_rec per_pay_proposals%ROWTYPE;

1249: l_new_pay_annual_factor NUMBER;
1250: l_new_currency VARCHAR2(15);
1251: l_new_annual_salary NUMBER;
1252: l_new_uom VARCHAR2(15);
1253: l_rec per_pay_proposals%ROWTYPE;
1254: --
1255: -- Cursor to get the pay proposal details
1256: --
1257: cursor get_prop_det (c_assignment_id in number,c_pay_basis_id in number) is

Line 1258: select * from per_pay_proposals pro

1254: --
1255: -- Cursor to get the pay proposal details
1256: --
1257: cursor get_prop_det (c_assignment_id in number,c_pay_basis_id in number) is
1258: select * from per_pay_proposals pro
1259: where pro.assignment_id = c_assignment_id
1260: and (p_effective_date - 1) between change_date and nvl(date_to,to_date('31/12/4712','dd/mm/yyyy'));
1261: -- and pro.pay_proposal_id = c_pay_basis_id;
1262: --

Line 1317: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

1313: hr_utility.set_location('l_prev_salary = '||to_char(l_prev_salary),13);
1314: --
1315: --Calculate the currency and pay_annualization_factor of the old salary basis
1316: --
1317: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1318: (p_effective_date => l_prev_change_date
1319: ,p_assignment_id => p_assignment_id
1320: ,p_currency => l_old_currency
1321: ,p_salary_basis_name => l_salary_basis_name

Line 1363: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS

1359: end if;
1360: --
1361: hr_utility.set_location('l_new_pay_annual_factor = '||to_char(l_new_pay_annual_factor),13);
1362: /**
1363: PER_PAY_PROPOSALS_POPULATE.GET_BASIS_DETAILS
1364: (p_effective_date => p_effective_date
1365: ,p_assignment_id => p_assignment_id
1366: ,p_currency => l_new_currency
1367: ,p_salary_basis_name => l_salary_basis_name

Line 1626: PER_PAY_PROPOSALS_POPULATE.get_asg_hours(p_assignment_id

1622: END;
1623: --Bug 8226280
1624: if (l_fte_profile_value = 'NHBGWH') then
1625:
1626: PER_PAY_PROPOSALS_POPULATE.get_asg_hours(p_assignment_id
1627: ,p_effective_date
1628: ,l_hours_per_year);
1629:
1630: if(nvl(l_hours_per_year,0) <> 0) then

Line 1631: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id

1627: ,p_effective_date
1628: ,l_hours_per_year);
1629:
1630: if(nvl(l_hours_per_year,0) <> 0) then
1631: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id
1632: ,p_effective_date
1633: ,l_norm_hours_per_year);
1634: if ( nvl(l_norm_hours_per_year,0) = 0) then
1635: l_fte_factor := 1;

Line 1674: from per_pay_proposals pro

1670: return varchar2 is
1671: l_dummy varchar2(10);
1672: CURSOR c_pay_proposals is
1673: select null
1674: from per_pay_proposals pro
1675: where pro.assignment_id = p_assignment_id
1676: and pro.change_date = p_date;
1677: begin
1678: OPEN c_pay_proposals;

Line 1693: from per_pay_proposals pro

1689: return date is
1690: l_min_change_date date;
1691: CURSOR c_pay_proposals is
1692: select min(change_date)
1693: from per_pay_proposals pro
1694: where pro.assignment_id = p_assignment_id;
1695: begin
1696: OPEN c_pay_proposals;
1697: FETCH c_pay_proposals into l_min_change_date;