DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PAY_PEOPLE_GROUPS

Line 1687: from pay_people_groups

1683: l_primary_asg_rec per_all_assignments_f%rowtype;
1684: --
1685: cursor get_pgp(p_people_group_id number) is
1686: select *
1687: from pay_people_groups
1688: where people_group_id=p_people_group_id;
1689: --
1690: l_pgp_rec pay_people_groups%rowtype :=NULL;
1691: l_primary_pgp_rec pay_people_groups%rowtype;

Line 1690: l_pgp_rec pay_people_groups%rowtype :=NULL;

1686: select *
1687: from pay_people_groups
1688: where people_group_id=p_people_group_id;
1689: --
1690: l_pgp_rec pay_people_groups%rowtype :=NULL;
1691: l_primary_pgp_rec pay_people_groups%rowtype;
1692: --
1693: cursor get_scl(p_soft_coding_keyflex_id number) is
1694: select *

Line 1691: l_primary_pgp_rec pay_people_groups%rowtype;

1687: from pay_people_groups
1688: where people_group_id=p_people_group_id;
1689: --
1690: l_pgp_rec pay_people_groups%rowtype :=NULL;
1691: l_primary_pgp_rec pay_people_groups%rowtype;
1692: --
1693: cursor get_scl(p_soft_coding_keyflex_id number) is
1694: select *
1695: from hr_soft_coding_keyflex