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 485: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp

481:
482: select gr.currency_code, gr.minimum, gr.mid_value, gr.maximum, petf.input_currency_code,
483: pb.grade_annualization_factor, ppp.proposed_salary_n, pb.pay_annualization_factor
484: from pay_input_values_f ivf, pay_element_types_f petf, pay_grade_rules_f gr,
485: per_pay_bases pb, per_assignments_f paf, per_pay_proposals ppp
486: where paf.assignment_id = p_assignment_id
487: AND paf.pay_basis_id = pb.pay_basis_id
488: and paf.assignment_id = ppp.assignment_id(+)
489: and pb.input_value_id = ivf.input_value_id

Line 740: FROM per_pay_proposals ppp, per_assignments_f paf

736: FUNCTION getAsgGradeRule(p_pay_proposal_id IN NUMBER) RETURN ROWID IS
737: l_rowid ROWID:=NULL;
738: CURSOR c_graderule IS
739: SELECT gr.rowid
740: FROM per_pay_proposals ppp, per_assignments_f paf
741: ,per_pay_bases pb, pay_grade_rules_f gr
742: WHERE ppp.pay_proposal_id = p_pay_proposal_id
743: AND ppp.assignment_id = paf.assignment_id
744: AND ppp.change_date between paf.effective_start_date and paf.effective_end_date

Line 762: FROM per_pay_proposals ppp, fnd_sessions fs

758: FUNCTION getAsgProposalId(p_assignment_id IN NUMBER) RETURN NUMBER IS
759: l_proposal_id Number := -1;
760: CURSOR c_proposal IS
761: SELECT nvl(max(pay_proposal_id),-1)
762: FROM per_pay_proposals ppp, fnd_sessions fs
763: WHERE fs.session_id = userenv('sessionid')
764: AND ppp.assignment_id = p_assignment_id
765: AND ppp.approved = 'Y'
766: AND fs.effective_date between ppp.change_date and ppp.date_to;

Line 1328: , per_pay_proposals ppp

1324: SELECT ppb.pay_annualization_factor
1325: , ppp.proposed_salary_n
1326: FROM per_pay_bases ppb
1327: , per_assignments_f paf
1328: , per_pay_proposals ppp
1329: WHERE paf.assignment_id = p_assign_id
1330: AND p_change_date BETWEEN paf.effective_start_date
1331: AND NVL(paf.effective_end_date, p_change_date)
1332: AND ppp.change_date = p_change_date