eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PER_ALL_PEOPLE_F

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

1425: l_last_updated pa_ci_actions_v.last_update_date%TYPE;
1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;
1432: -- Bug#12553936 start
1433: l_task_name pa_proj_elements.name%TYPE;

Line 1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347

1426: l_action_status_meaning pa_ci_actions_v.status_meaning%TYPE;
1427: l_sign_off_req_flag pa_ci_actions_v.sign_off_required_flag%TYPE;
1428: l_sign_off_req_meaning pa_ci_actions_v.sign_off_required_flag_meaning%TYPE;
1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;
1432: -- Bug#12553936 start
1433: l_task_name pa_proj_elements.name%TYPE;
1434: l_task_number pa_proj_elements.element_number%TYPE;

Line 1537: per_all_people_f papf

1533: select fu.user_name, hp.party_name, hp.email_address
1534: from
1535: fnd_user fu,
1536: hz_parties hp,
1537: per_all_people_f papf
1538: where
1539: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
1540: AND 'PER:' = Substr(hp.orig_system_reference,1,4)
1541: and hp.party_id = c_owner_id

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

1572: connect by prior source_ci_action_id = ci_action_id;
1573:
1574: -- Added the cursor for bug 4049901
1575: -- This cursor gets the full name of the assignee of an action
1576: Cursor get_role_display_name( p_party_id per_all_people_f.party_id%TYPE)
1577: IS
1578: select full_name,email_address
1579: from per_all_people_f
1580: where party_id= p_party_id

Line 1579: from per_all_people_f

1575: -- This cursor gets the full name of the assignee of an action
1576: Cursor get_role_display_name( p_party_id per_all_people_f.party_id%TYPE)
1577: IS
1578: select full_name,email_address
1579: from per_all_people_f
1580: where party_id= p_party_id
1581: and sysdate between nvl(effective_start_date,sysdate) and nvl(effective_end_date,sysdate)
1582: and rownum=1;
1583: -- Bug 8673347 added email_address to above cursor