DBA Data[Home] [Help]

APPS.PER_EVENTS_PKG dependencies on PER_PEOPLE_F

Line 26: FROM per_people_f

22:
23:
24: CURSOR CH1 IS
25: SELECT 1
26: FROM per_people_f
27: where person_id= X_INTERNAL_CONTACT_PERSON_ID
28: AND X_DATE_START BETWEEN
29: effective_Start_date and effective_end_Date;
30:

Line 49: FROM PER_PEOPLE_F P,

45: --- commented to allow update of organization run by of events.
46: ---
47: /* CURSOR CH4 IS
48: SELECT 1
49: FROM PER_PEOPLE_F P,
50: PER_BOOKINGS B
51: WHERE P.PERSON_ID = B.PERSON_ID
52: AND B.EVENT_ID = X_EVENT_ID;
53:

Line 56: FROM PER_PEOPLE_F P,

52: AND B.EVENT_ID = X_EVENT_ID;
53:
54: CURSOR CH5 IS
55: SELECT 1
56: FROM PER_PEOPLE_F P,
57: PER_BOOKINGS B
58: WHERE P.PERSON_ID = B.PERSON_ID
59: AND B.EVENT_ID = X_EVENT_ID
60: AND X_DATE_START BETWEEN