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_PROGRESS_REPORT_WORKFLOW dependencies on PER_ALL_PEOPLE_F

Line 1046: fnd_user fu,per_all_people_f papf

1042: IS
1043: SELECT papf.full_name person_name,
1044: papf.email_address
1045: FROM
1046: fnd_user fu,per_all_people_f papf
1047: where fu.employee_id = papf.person_id
1048: AND fu.user_name = l_user_name
1049: AND trunc(sysdate) between papf.EFFECTIVE_START_DATE
1050: and Nvl(papf.effective_end_date, Sysdate + 1)

Line 1260: fnd_user fu,per_all_people_f papf

1256: fu.user_name,
1257: papf.email_address,
1258: papf.full_name person_name
1259: from
1260: fnd_user fu,per_all_people_f papf
1261: where
1262: fu.employee_id = l_approver_id
1263: and papf.person_id = fu.employee_id
1264: and trunc(sysdate)

Line 1277: fnd_user fu,per_all_people_f papf

1273: fu.user_name,
1274: papf.email_address,
1275: papf.full_name person_name
1276: from
1277: fnd_user fu,per_all_people_f papf
1278: where
1279: fu.person_party_id = l_approver_id -- Bug 4527617. Replaced customer_id with person_party_id.
1280: and papf.person_id = fu.employee_id
1281: and trunc(sysdate)

Line 1296: fnd_user fu,per_all_people_f papf

1292: papf.full_name person_name,
1293: ppp.resource_source_id
1294: from
1295: pa_project_parties ppp,
1296: fnd_user fu,per_all_people_f papf
1297: where ppp.project_id = l_project_id
1298: and ppp.project_role_id = To_number(l_role_id)
1299: and ppp.project_id = ppp.object_id
1300: AND fu.employee_id = ppp.resource_source_id

Line 1321: fnd_user fu,per_all_people_f p2,

1317: p2.email_address,
1318: p2.full_name person_name
1319: from
1320: pa_proj_parties_prog_ev_v ppp,
1321: fnd_user fu,per_all_people_f p2,
1322: per_assignments_f p1
1323: where ppp.project_id = l_project_id
1324: and ppp.project_role_id = 1
1325: and ppp.resource_source_id = p1.person_id

Line 2059: per_all_people_f papf

2055: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2056: pa_progress_reports_v pprv,
2057: pa_lookups pl,
2058: pa_project_parties ppp,
2059: per_all_people_f papf
2060: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2061: AND pl.lookup_code = pprv.progress_status_code
2062: and pprv.version_id = document_id
2063: AND pprv.object_type = 'PA_PROJECTS'

Line 2080: from per_all_people_f papf,

2076: AND pprv.object_type = 'PA_PROJECTS';*/
2077:
2078: CURSOR c_reporter_list IS
2079: select usr.user_id, usr.person_party_id, usr.user_name,papf.email_address,papf.full_name person_name -- Bug 4527617. Replaced customer_id with person_party_id.
2080: from per_all_people_f papf,
2081: fnd_user usr
2082: WHERE
2083: papf.person_id = usr.employee_id
2084: and trunc(sysdate)

Line 2197: per_all_people_f papf

2193: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2194: pa_progress_reports_v pprv,
2195: pa_lookups pl,
2196: pa_project_parties ppp,
2197: per_all_people_f papf
2198: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2199: AND pl.lookup_code = pprv.progress_status_code
2200: and pprv.version_id = document_id
2201: AND pprv.object_type = 'PA_PROJECTS'

Line 2218: from per_all_people_f papf,

2214: AND pprv.object_type = 'PA_PROJECTS';*/
2215:
2216: /* CURSOR c_reporter_list IS
2217: select usr.user_id, usr.customer_id, usr.user_name,papf.email_address,papf.full_name person_name
2218: from per_all_people_f papf,
2219: fnd_user usr
2220: WHERE
2221: papf.person_id = usr.employee_id
2222: and trunc(sysdate)

Line 2347: per_all_people_f papf

2343: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2344: pa_progress_report_vers pprv,
2345: pa_lookups pl,
2346: pa_project_parties ppp,
2347: per_all_people_f papf
2348: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2349: AND pl.lookup_code = pprv.progress_status_code
2350: and pprv.version_id = document_id
2351: AND pprv.object_type = 'PA_PROJECTS'

Line 2380: from per_all_people_f papf,

2376:
2377: /*
2378: CURSOR c_reporter_list IS
2379: select usr.user_id, usr.customer_id, usr.user_name,papf.email_address,papf.full_name person_name
2380: from per_all_people_f papf,
2381: fnd_user usr
2382: WHERE
2383: papf.person_id = usr.employee_id
2384: and trunc(sysdate)