APPS.HR_PERSON_API dependencies on PER_BUSINESS_GROUPS

Line 1238: l_legislation_code per_business_groups.legislation_code%type;

1234: --
1235:
1236: l_proc varchar2(72) := g_package||'update_gb_person';
1237: l_effective_date date;
1238: l_legislation_code per_business_groups.legislation_code%type;
1239: l_discard_varchar2 varchar2(30);
1240: --
1241: /*cursor check_legislation
1242: (c_person_id per_people_f.person_id%TYPE,

Line 1248: per_business_groups bgp

1244: )
1245: is
1246: select bgp.legislation_code
1247: from per_people_f per,
1248: per_business_groups bgp
1249: where per.business_group_id = bgp.business_group_id
1250: and per.person_id = c_person_id
1251: and c_effective_date
1252: between per.effective_start_date and per.effective_end_date;

Line 1263: per_business_groups_perf bgp

1259: )
1260: is
1261: select bgp.legislation_code
1262: from per_people_f per,
1263: per_business_groups_perf bgp
1264: where per.business_group_id+0 = bgp.business_group_id
1265: and per.person_id = c_person_id
1266: and c_effective_date
1267: between per.effective_start_date and per.effective_end_date;

Line 1569: l_legislation_code per_business_groups.legislation_code%type;

1565: -- Declare cursors and local variables
1566: --
1567: l_proc varchar2(72) := g_package||'update_us_person';
1568: l_effective_date date;
1569: l_legislation_code per_business_groups.legislation_code%type;
1570: l_discard_varchar2 varchar2(30);
1571: --
1572: cursor check_legislation
1573: (c_person_id per_people_f.person_id%TYPE,

Line 1579: -- per_business_groups bgp -- 6131445

1575: )
1576: is
1577: select bgp.legislation_code
1578: from per_people_f per,
1579: -- per_business_groups bgp -- 6131445
1580: -- where per.business_group_id = bgp.business_group_id
1581: per_business_groups_perf bgp
1582: where per.business_group_id+0 = bgp.business_group_id
1583: and per.person_id = c_person_id

Line 1581: per_business_groups_perf bgp

1577: select bgp.legislation_code
1578: from per_people_f per,
1579: -- per_business_groups bgp -- 6131445
1580: -- where per.business_group_id = bgp.business_group_id
1581: per_business_groups_perf bgp
1582: where per.business_group_id+0 = bgp.business_group_id
1583: and per.person_id = c_person_id
1584: and c_effective_date
1585: between per.effective_start_date and per.effective_end_date;