APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PER_ALL_PEOPLE_F

Line 1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901

1322: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1323: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1324: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1325: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1326: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1327:
1328: -- This cursor gets the info about the control item.
1329: CURSOR get_ci_info
1330: IS

Line 1424: per_all_people_f papf

1420: select fu.user_name, hp.party_name, hp.email_address
1421: from
1422: fnd_user fu,
1423: hz_parties hp,
1424: per_all_people_f papf
1425: where
1426: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
1427: AND 'PER:' = Substr(hp.orig_system_reference,1,4)
1428: and hp.party_id = c_owner_id

Line 1463: Cursor get_role_display_name( p_party_id per_all_people_f.party_id%TYPE)

1459: connect by prior source_ci_action_id = ci_action_id;
1460:
1461: -- Added the cursor for bug 4049901
1462: -- This cursor gets the full name of the assignee of an action
1463: Cursor get_role_display_name( p_party_id per_all_people_f.party_id%TYPE)
1464: IS
1465: select full_name
1466: from per_all_people_f
1467: where party_id= p_party_id

Line 1466: from per_all_people_f

1462: -- This cursor gets the full name of the assignee of an action
1463: Cursor get_role_display_name( p_party_id per_all_people_f.party_id%TYPE)
1464: IS
1465: select full_name
1466: from per_all_people_f
1467: where party_id= p_party_id
1468: and sysdate between nvl(effective_start_date,sysdate) and nvl(effective_end_date,sysdate)
1469: and rownum=1;
1470: