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
5093: THEN
5094: --The buyer on Source Document should be in the same business group as
5095: --the requesting operating unit(current OU) or the profile option HR: Cross
5096: --Business Group should be set to 'Y'. These two conditions are checked in
5097: --view definition of per_people_f
5098: BEGIN
5099: SELECT 'Y'
5100: INTO l_buyer_ok
5101: FROM per_people_f ppf
5097: --view definition of per_people_f
5098: BEGIN
5099: SELECT 'Y'
5100: INTO l_buyer_ok
5101: FROM per_people_f ppf
5102: WHERE x_buyer_id = ppf.person_id
5103: AND trunc(sysdate) between ppf.effective_start_date
5104: AND NVL(ppf.effective_end_date, sysdate +1);
5105: EXCEPTION WHEN OTHERS THEN