DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PAY_PEOPLE_GROUPS

Line 1908: from pay_people_groups

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;

Line 1911: l_pgp_rec pay_people_groups%rowtype :=NULL;

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 *

Line 1912: l_primary_pgp_rec pay_people_groups%rowtype;

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

Line 4389: from pay_people_groups

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;

Line 4392: l_pgp_rec pay_people_groups%rowtype :=NULL;

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 *

Line 4393: l_primary_pgp_rec pay_people_groups%rowtype;

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