DBA Data[Home] [Help]

APPS.PAY_PAYUSRRS_XMLP_PKG dependencies on PER_PEOPLE_F

Line 36: from per_people_f ppf

32:
33: if p_person_id IS NOT NULL then
34:
35: Select distinct ppf.full_name into c_person_name
36: from per_people_f ppf
37: where ppf.person_id = p_person_id;
38: end if;
39: if p_assignment_number IS NOT NULL then
40:

Line 42: from per_people_f ppf,

38: end if;
39: if p_assignment_number IS NOT NULL then
40:
41: Select ppf.full_name into c_person_name
42: from per_people_f ppf,
43: per_all_assignments_f paa
44: where paa.person_id = ppf.person_id
45: and paa.assignment_number = p_assignment_number;
46: end if;