DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PER_PEOPLE_F

Line 441: --view definition of per_people_f

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

Line 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

Line 5139: --view definition of per_people_f

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

Line 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