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 5097: --view definition of per_people_f

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

Line 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