DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on PER_BUSINESS_GROUPS

Line 9: cur_business_group_id per_business_groups.business_group_id%type;

5: g_proc varchar2(72) DEFAULT NULL;
6: l_log_text varchar2(2000);
7: l_noaerrbuf varchar2(2000) DEFAULT NULL;
8: l_mcanerrbuf varchar2(2000) DEFAULT NULL;
9: cur_business_group_id per_business_groups.business_group_id%type;
10: g_effective_date date;
11: l_noa_code ghr_mass_salaries.noa_code%type;
12: l_nte_date ghr_mass_salaries.nte_date%type;
13: l_target_barg_unit_status ghr_mass_salaries.target_bargaining_unit_status%type;

Line 1895: CURSOR vacant_pos (g_business_group_id per_business_groups.business_group_id%type,

1891: AND paf.organization_id = hou.organization_id
1892: AND paf.position_id IS NOT NULL
1893: ORDER BY ppf.person_id;
1894:
1895: CURSOR vacant_pos (g_business_group_id per_business_groups.business_group_id%type,
1896: effective_date date) is
1897: SELECT null PERSON_ID,
1898: 'VACANT' FIRST_NAME,
1899: 'VACANT' LAST_NAME,