APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PAY_PROPOSALS

Line 363: from per_pay_proposals p1

359: cursor csr_pay_proposal
360: (p_assignment_id number
361: ,p_effective_date date) is
362: select *
363: from per_pay_proposals p1
364: where p1.assignment_id=p_assignment_id
365: and p1.change_date=
366: (select max(p2.change_date)
367: from per_pay_proposals p2

Line 367: from per_pay_proposals p2

363: from per_pay_proposals p1
364: where p1.assignment_id=p_assignment_id
365: and p1.change_date=
366: (select max(p2.change_date)
367: from per_pay_proposals p2
368: where p2.assignment_id=p_assignment_id
369: and change_date<=p_effective_date)
370: and p1.date_to >= p_effective_date; -- Fix For Bug # 8494017
371: --

Line 483: pyp_rec per_pay_proposals%rowtype;

479: addr_rec per_addresses%rowtype;
480: asg_rec per_all_assignments_f%rowtype;
481: pgp_rec pay_people_groups%rowtype;
482: scl_rec hr_soft_coding_keyflex%rowtype;
483: pyp_rec per_pay_proposals%rowtype;
484: dpf_rec per_deployment_factors%rowtype;
485: chk_rec per_checklist_items%rowtype;
486: --
487: l_end_of_time date;

Line 2009: per_pay_proposals_populate.get_currency_format(out_rec.currency_code,out_rec.salary_format);

2005: ,out_rec.currency_code
2006: ,l_uom;
2007: close salary_basis;
2008: if l_uom='M' then
2009: per_pay_proposals_populate.get_currency_format(out_rec.currency_code,out_rec.salary_format);
2010: else
2011: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
2012: end if;
2013: end if;

Line 2011: per_pay_proposals_populate.get_number_format(out_rec.salary_format);

2007: close salary_basis;
2008: if l_uom='M' then
2009: per_pay_proposals_populate.get_currency_format(out_rec.currency_code,out_rec.salary_format);
2010: else
2011: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
2012: end if;
2013: end if;
2014: out_rec.pay_basis_id :=asg_rec.pay_basis_id;
2015: out_rec.pay_basis_meaning :=hr_reports.get_lookup_meaning('PAY_BASIS',out_rec.pay_basis);