DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on PAY_PEOPLE_GROUPS

Line 17: l_ppl_grp_rec pay_people_groups%ROWTYPE;

13: l_add_rec per_addresses%ROWTYPE;
14: l_cntct_rec per_contact_relationships%ROWTYPE;
15: l_phones_rec per_phones%ROWTYPE;
16: l_hr_soft_rec hr_soft_coding_keyflex%ROWTYPE;
17: l_ppl_grp_rec pay_people_groups%ROWTYPE;
18:
19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE
21: ,assignment_id per_all_assignments_f.assignment_id%TYPE

Line 40: ,group_name pay_people_groups.group_name%TYPE

36: (asg_object_version_number per_all_assignments_f.object_version_number%TYPE
37: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE
38: ,people_group_id per_all_assignments_f.people_group_id%TYPE
39: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
40: ,group_name pay_people_groups.group_name%TYPE
41: ,asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
42: ,asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
43: ,org_now_no_manager_warning Boolean
44: ,other_manager_warning Boolean

Line 599: FROM pay_people_groups

595:
596: -- Cursor to get people group flexfield details
597: CURSOR csr_ppg (c_people_grp_id IN Number) IS
598: SELECT *
599: FROM pay_people_groups
600: WHERE people_group_id = c_people_grp_id;
601:
602: l_cur_ppl_grp_rec pay_people_groups%ROWTYPE;
603:

Line 602: l_cur_ppl_grp_rec pay_people_groups%ROWTYPE;

598: SELECT *
599: FROM pay_people_groups
600: WHERE people_group_id = c_people_grp_id;
601:
602: l_cur_ppl_grp_rec pay_people_groups%ROWTYPE;
603:
604: -- Cursor to get Soft coding flexfield details
605: CURSOR csr_scl (c_scl_kff_id IN Number) IS
606: SELECT *