DBA Data[Home] [Help]

APPS.HR_NEW_USER_REG_SS dependencies on PER_ALL_PEOPLE_F

Line 45: cursor csr_person is select person_id from per_all_people_f where person_id = PersonId;

41: WfItemKey in varchar2,
42: PersonId in out nocopy varchar2,
43: AssignmentId in out nocopy varchar2) is
44:
45: cursor csr_person is select person_id from per_all_people_f where person_id = PersonId;
46:
47: cursor csr_txn_step_id is
48: select trs.transaction_step_id
49: from hr_api_transaction_steps trs

Line 58: l_newUserPersonId per_all_people_f.person_id%type;

54:
55: l_transaction_step_id number;
56: l_business_grp_Id number;
57:
58: l_newUserPersonId per_all_people_f.person_id%type;
59: l_result varchar2(100);
60: l_proc varchar2(72) := g_package||'processNewUserTransaction';
61: begin
62: