DBA Data[Home] [Help]

APPS.AME_UTIL dependencies on PER_ALL_PEOPLE_F

Line 1919: firstName per_all_people_f.first_name%type;

1915: procedure apprRecord2ToApprRecord(approverRecord2In in ame_util.approverRecord2,
1916: approverRecordOut out nocopy ame_util.approverRecord) is
1917: errorCode integer;
1918: errorMessage ame_util.longestStringType;
1919: firstName per_all_people_f.first_name%type;
1920: lastName per_all_people_f.last_name%type;
1921: tempOrigSystem ame_util.stringType;
1922: tempOrigSystemId integer;
1923: userName fnd_user.user_name%type;

Line 1920: lastName per_all_people_f.last_name%type;

1916: approverRecordOut out nocopy ame_util.approverRecord) is
1917: errorCode integer;
1918: errorMessage ame_util.longestStringType;
1919: firstName per_all_people_f.first_name%type;
1920: lastName per_all_people_f.last_name%type;
1921: tempOrigSystem ame_util.stringType;
1922: tempOrigSystemId integer;
1923: userName fnd_user.user_name%type;
1924: wrongCategory exception;

Line 1950: from per_all_people_f pap

1946: select pap.first_name
1947: ,pap.last_name
1948: into firstName
1949: ,lastName
1950: from per_all_people_f pap
1951: ,per_all_assignments_f pas
1952: where pap.person_id = approverRecordOut.person_id
1953: and pap.person_id = pas.person_id
1954: and pas.primary_flag = 'Y'

Line 2147: firstName per_all_people_f.first_name%type;

2143: ct integer;
2144: errorCode integer;
2145: errorMessage ame_util.longestStringType;
2146: errorWfName ame_util.stringType;
2147: firstName per_all_people_f.first_name%type;
2148: lastName per_all_people_f.last_name%type;
2149: tempOrigSystem ame_util.stringType;
2150: tempOrigSystemId integer;
2151: userName fnd_user.user_name%type;

Line 2148: lastName per_all_people_f.last_name%type;

2144: errorCode integer;
2145: errorMessage ame_util.longestStringType;
2146: errorWfName ame_util.stringType;
2147: firstName per_all_people_f.first_name%type;
2148: lastName per_all_people_f.last_name%type;
2149: tempOrigSystem ame_util.stringType;
2150: tempOrigSystemId integer;
2151: userName fnd_user.user_name%type;
2152: wrongCategory exception;

Line 2180: from per_all_people_f pap

2176: select pap.first_name
2177: ,pap.last_name
2178: into firstName
2179: ,lastName
2180: from per_all_people_f pap
2181: ,per_all_assignments_f pas
2182: where pap.person_id = approversTableOut(ct).person_id
2183: and pap.person_id = pas.person_id
2184: and pas.primary_flag = 'Y'