1904: l_primary_asg_rec per_all_assignments_f%rowtype;
1905: --
1906: cursor get_pgp(p_people_group_id number) is
1907: select *
1908: from pay_people_groups
1909: where people_group_id=p_people_group_id;
1910: --
1911: l_pgp_rec pay_people_groups%rowtype :=NULL;
1912: l_primary_pgp_rec pay_people_groups%rowtype;
1907: select *
1908: from pay_people_groups
1909: where people_group_id=p_people_group_id;
1910: --
1911: l_pgp_rec pay_people_groups%rowtype :=NULL;
1912: l_primary_pgp_rec pay_people_groups%rowtype;
1913: --
1914: cursor get_scl(p_soft_coding_keyflex_id number) is
1915: select *
1908: from pay_people_groups
1909: where people_group_id=p_people_group_id;
1910: --
1911: l_pgp_rec pay_people_groups%rowtype :=NULL;
1912: l_primary_pgp_rec pay_people_groups%rowtype;
1913: --
1914: cursor get_scl(p_soft_coding_keyflex_id number) is
1915: select *
1916: from hr_soft_coding_keyflex
4385: l_primary_asg_rec per_all_assignments_f%rowtype;
4386: --
4387: cursor get_pgp(p_people_group_id number) is
4388: select *
4389: from pay_people_groups
4390: where people_group_id=p_people_group_id;
4391: --
4392: l_pgp_rec pay_people_groups%rowtype :=NULL;
4393: l_primary_pgp_rec pay_people_groups%rowtype;
4388: select *
4389: from pay_people_groups
4390: where people_group_id=p_people_group_id;
4391: --
4392: l_pgp_rec pay_people_groups%rowtype :=NULL;
4393: l_primary_pgp_rec pay_people_groups%rowtype;
4394: --
4395: cursor get_scl(p_soft_coding_keyflex_id number) is
4396: select *
4389: from pay_people_groups
4390: where people_group_id=p_people_group_id;
4391: --
4392: l_pgp_rec pay_people_groups%rowtype :=NULL;
4393: l_primary_pgp_rec pay_people_groups%rowtype;
4394: --
4395: cursor get_scl(p_soft_coding_keyflex_id number) is
4396: select *
4397: from hr_soft_coding_keyflex