APPS.HR_SA_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 244: l_legislation_code per_business_groups.legislation_code%type;

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

Line 255: per_business_groups bgp,

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