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

1571:
1572: /*
1573: l_proc varchar2(72) := g_package||'update_us_person';
1574: l_effective_date date;
1575: l_legislation_code per_business_groups.legislation_code%type;
1576: l_discard_varchar2 varchar2(30);
1577: */
1578: --
1579: /*

Line 1587: -- per_business_groups bgp -- 6131445

1583: )
1584: is
1585: select bgp.legislation_code
1586: from per_people_f per,
1587: -- per_business_groups bgp -- 6131445
1588: -- where per.business_group_id = bgp.business_group_id
1589: per_business_groups_perf bgp
1590: where per.business_group_id+0 = bgp.business_group_id
1591: and per.person_id = c_person_id

Line 1589: per_business_groups_perf bgp

1585: select bgp.legislation_code
1586: from per_people_f per,
1587: -- per_business_groups bgp -- 6131445
1588: -- where per.business_group_id = bgp.business_group_id
1589: per_business_groups_perf bgp
1590: where per.business_group_id+0 = bgp.business_group_id
1591: and per.person_id = c_person_id
1592: and c_effective_date
1593: between per.effective_start_date and per.effective_end_date;

Line 1901: l_legislation_code per_business_groups.legislation_code%type;

1897: -- Declare cursors and local variables
1898: --
1899: l_proc varchar2(72) := g_package||'update_us_person';
1900: l_effective_date date;
1901: l_legislation_code per_business_groups.legislation_code%type;
1902: l_discard_varchar2 varchar2(30);
1903: --
1904: cursor check_legislation
1905: (c_person_id per_people_f.person_id%TYPE,

Line 1911: -- per_business_groups bgp -- 6131445

1907: )
1908: is
1909: select bgp.legislation_code
1910: from per_people_f per,
1911: -- per_business_groups bgp -- 6131445
1912: -- where per.business_group_id = bgp.business_group_id
1913: per_business_groups_perf bgp
1914: where per.business_group_id+0 = bgp.business_group_id
1915: and per.person_id = c_person_id

Line 1913: per_business_groups_perf bgp

1909: select bgp.legislation_code
1910: from per_people_f per,
1911: -- per_business_groups bgp -- 6131445
1912: -- where per.business_group_id = bgp.business_group_id
1913: per_business_groups_perf bgp
1914: where per.business_group_id+0 = bgp.business_group_id
1915: and per.person_id = c_person_id
1916: and c_effective_date
1917: between per.effective_start_date and per.effective_end_date;