437: --
438: --The buyer on Source Document should be in the same business group as
439: --the requesting operating unit(current OU) or the profile option HR: Cross
440: --Business Group should be set to 'Y'. These two conditions are checked in
441: --view definition of per_people_f
442: BEGIN
443: SELECT 'Y'
444: INTO l_buyer_ok
445: FROM per_people_f ppf
441: --view definition of per_people_f
442: BEGIN
443: SELECT 'Y'
444: INTO l_buyer_ok
445: FROM per_people_f ppf
446: WHERE x_buyer_id = ppf.person_id
447: AND trunc(sysdate) between ppf.effective_start_date
448: AND NVL(ppf.effective_end_date, sysdate +1);
449: EXCEPTION WHEN OTHERS THEN
5135: THEN
5136: --The buyer on Source Document should be in the same business group as
5137: --the requesting operating unit(current OU) or the profile option HR: Cross
5138: --Business Group should be set to 'Y'. These two conditions are checked in
5139: --view definition of per_people_f
5140: BEGIN
5141: SELECT 'Y'
5142: INTO l_buyer_ok
5143: FROM per_people_f ppf
5139: --view definition of per_people_f
5140: BEGIN
5141: SELECT 'Y'
5142: INTO l_buyer_ok
5143: FROM per_people_f ppf
5144: WHERE x_buyer_id = ppf.person_id
5145: AND trunc(sysdate) between ppf.effective_start_date
5146: AND NVL(ppf.effective_end_date, sysdate +1);
5147: EXCEPTION WHEN OTHERS THEN