APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PAY_PROPOSALS

Line 334: from per_pay_proposals p1

330: cursor csr_pay_proposal
331: (p_assignment_id number
332: ,p_effective_date date) is
333: select *
334: from per_pay_proposals p1
335: where p1.assignment_id=p_assignment_id
336: and p1.change_date=
337: (select max(p2.change_date)
338: from per_pay_proposals p2

Line 338: from per_pay_proposals p2

334: from per_pay_proposals p1
335: where p1.assignment_id=p_assignment_id
336: and p1.change_date=
337: (select max(p2.change_date)
338: from per_pay_proposals p2
339: where p2.assignment_id=p_assignment_id
340: and change_date<=p_effective_date);
341: --
342: cursor csr_deployment

Line 453: pyp_rec per_pay_proposals%rowtype;

449: addr_rec per_addresses%rowtype;
450: asg_rec per_all_assignments_f%rowtype;
451: pgp_rec pay_people_groups%rowtype;
452: scl_rec hr_soft_coding_keyflex%rowtype;
453: pyp_rec per_pay_proposals%rowtype;
454: dpf_rec per_deployment_factors%rowtype;
455: chk_rec per_checklist_items%rowtype;
456: --
457: l_end_of_time date;

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

1971: ,out_rec.currency_code
1972: ,l_uom;
1973: close salary_basis;
1974: if l_uom='M' then
1975: per_pay_proposals_populate.get_currency_format(out_rec.currency_code,out_rec.salary_format);
1976: else
1977: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
1978: end if;
1979: end if;

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

1973: close salary_basis;
1974: if l_uom='M' then
1975: per_pay_proposals_populate.get_currency_format(out_rec.currency_code,out_rec.salary_format);
1976: else
1977: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
1978: end if;
1979: end if;
1980: out_rec.pay_basis_id :=asg_rec.pay_basis_id;
1981: out_rec.pay_basis_meaning :=hr_reports.get_lookup_meaning('PAY_BASIS',out_rec.pay_basis);