APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_PEOPLE_GROUPS

Line 258: select * from pay_people_groups

254: where recruitment_activity_id=p_recruitment_activity_id;
255: --
256: cursor csr_pgp_rec
257: (p_people_group_id number) is
258: select * from pay_people_groups
259: where people_group_id=p_people_group_id;
260: --
261: cursor csr_scl_rec
262: (p_soft_coding_keyflex_id number) is

Line 451: pgp_rec pay_people_groups%rowtype;

447: pds_rec per_periods_of_service%rowtype;
448: pdp_rec per_periods_of_placement%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;