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_MEE_VIEWS_GEN dependencies on PER_PAY_PROPOSALS

Line 231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf

227: 0, 1,
228: ppb.pay_annualization_factor) * ppp.proposed_salary_n
229: ,petf.input_currency_code
230: FROM per_pay_bases ppb, per_assignments_f paf
231: ,per_pay_proposals ppp, pay_input_values_f ivf, pay_element_types_f petf
232: WHERE paf.person_id = p_person_id
233: AND paf.primary_flag = 'Y'
234: AND paf.assignment_type = 'E'
235: AND ppb.input_value_id = ivf.input_value_id

Line 241: AND ppp.change_date = (SELECT max(change_date) FROM per_pay_proposals ippp

237: AND ppp.change_date BETWEEN ivf.effective_start_date AND ivf.effective_end_date
238: AND ppp.change_date BETWEEN petf.effective_start_date AND petf.effective_end_date
239: AND ppp.change_date BETWEEN paf.effective_start_date AND paf.effective_end_date
240: AND ppp.assignment_id = paf.assignment_id
241: AND ppp.change_date = (SELECT max(change_date) FROM per_pay_proposals ippp
242: WHERE ippp.assignment_id = paf.assignment_id
243: AND ippp.approved = 'Y'
244: AND ippp.change_date <= getEffDate)
245: AND ppb.pay_basis_id = paf.pay_basis_id;

Line 442: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp

438:
439: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
440: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
441: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
442: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
443: where paf.assignment_id = p_assignment_id
444: AND paf.pay_basis_id = pb.pay_basis_id
445: and paf.assignment_id = ppp.assignment_id(+)
446: and pb.input_value_id = ivf.input_value_id

Line 697: FROM per_pay_proposals ppp, per_assignments_f paf

693: FUNCTION getAsgGradeRule(p_pay_proposal_id IN NUMBER) RETURN ROWID IS
694: l_rowid ROWID:=NULL;
695: CURSOR c_graderule IS
696: SELECT gr.rowid
697: FROM per_pay_proposals ppp, per_assignments_f paf
698: ,per_pay_bases pb, pay_grade_rules_f gr
699: WHERE ppp.pay_proposal_id = p_pay_proposal_id
700: AND ppp.assignment_id = paf.assignment_id
701: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date

Line 719: FROM per_pay_proposals ppp, fnd_sessions fs

715: FUNCTION getAsgProposalId(p_assignment_id IN NUMBER) RETURN NUMBER IS
716: l_proposal_id Number := -1;
717: CURSOR c_proposal IS
718: SELECT nvl(max(pay_proposal_id),-1)
719: FROM per_pay_proposals ppp, fnd_sessions fs
720: WHERE fs.session_id = userenv('sessionid')
721: AND ppp.assignment_id = p_assignment_id
722: AND ppp.approved = 'Y'
723: AND ppp.change_date <= fs.effective_date;

Line 1285: , per_pay_proposals ppp

1281: SELECT ppb.pay_annualization_factor
1282: , ppp.proposed_salary_n
1283: FROM per_pay_bases ppb
1284: , per_assignments_f paf
1285: , per_pay_proposals ppp
1286: WHERE paf.assignment_id = p_assign_id
1287: AND p_change_date BETWEEN paf.effective_start_date
1288: AND NVL(paf.effective_end_date, p_change_date)
1289: AND ppp.change_date = p_change_date