APPS.PQP_HROSS_INTEGRATION dependencies on PER_BUSINESS_GROUPS

Line 123: FROM per_business_groups pbg

119: -- Cursor to get the leg. code
120: CURSOR csr_bg_code (c_bg_grp_id IN Number) IS
121: SELECT pbg.legislation_code
122: ,pbg.method_of_generation_emp_num
123: FROM per_business_groups pbg
124: WHERE pbg.business_group_id = c_bg_grp_id;
125:
126: -- Cursor to get the meaning and code for a lookup type
127: CURSOR csr_chk_code (c_lookup_type IN Varchar2

Line 5615: FROM per_business_groups_perf

5611: BEGIN
5612: SELECT format_type INTO l_format_type
5613: FROM FND_ID_FLEX_SEGMENTS_VL a, fnd_flex_value_sets b
5614: WHERE id_flex_num = (SELECT people_group_structure
5615: FROM per_business_groups_perf
5616: WHERE business_group_id = p_business_group_id)
5617: AND a.flex_value_set_id = b.flex_value_set_id
5618: AND 'p_people_'||lower(application_column_name) = p_seg_name;
5619:

Line 6715: FROM per_business_groups pbg

6711:
6712: -- Cursor to get the business group name
6713: CURSOR csr_get_bg_name (c_bg_grp_id IN Number) IS
6714: SELECT pbg.NAME
6715: FROM per_business_groups pbg
6716: WHERE pbg.business_group_id = c_bg_grp_id;
6717:
6718: l_bg_name per_business_groups.NAME%TYPE;
6719: l_proc_name CONSTANT Varchar2(150):= g_pkg ||

Line 6718: l_bg_name per_business_groups.NAME%TYPE;

6714: SELECT pbg.NAME
6715: FROM per_business_groups pbg
6716: WHERE pbg.business_group_id = c_bg_grp_id;
6717:
6718: l_bg_name per_business_groups.NAME%TYPE;
6719: l_proc_name CONSTANT Varchar2(150):= g_pkg ||
6720: 'Create_BatchHdr_For_DataPump';
6721:
6722: BEGIN