APPS.HR_AE_PREVIOUS_EMPLOYMENT_API dependencies on PER_BUSINESS_GROUPS

Line 68: l_legislation_code per_business_groups.legislation_code%type;

64: --
65:
66: l_proc varchar2(72) ;
67: l_effective_date date;
68: l_legislation_code per_business_groups.legislation_code%type;
69: l_discard_varchar2 varchar2(30);
70: --
71:
72: cursor check_legislation

Line 79: per_business_groups bgp

75: )
76: is
77: select bgp.legislation_code
78: from per_people_f per,
79: per_business_groups bgp
80: where per.business_group_id = bgp.business_group_id
81: and per.person_id = c_person_id
82: and c_effective_date
83: between per.effective_start_date and per.effective_end_date;

Line 245: l_legislation_code per_business_groups.legislation_code%type;

241: --
242:
243: l_proc varchar2(72) ;
244: l_effective_date date;
245: l_legislation_code per_business_groups.legislation_code%type;
246: l_discard_varchar2 varchar2(30);
247: --
248:
249: cursor check_legislation

Line 256: per_business_groups bgp,

252: )
253: is
254: select bgp.legislation_code
255: from per_people_f per,
256: per_business_groups bgp,
257: per_previous_employers pem
258: where per.business_group_id = bgp.business_group_id
259: and per.person_id = pem.person_id
260: and pem.previous_employer_id = c_previous_employer_id