[Home] [Help]
52: 08-Sep-05 raluthra Bug 4565156. Added code for Manual NOCOPY Changes
53: for usage of same variable for In and Out parameter.
54: 01-Feb-06 vgottimu Bug 4923945. Changed the cursor cur_ci_status_n_owner query,
55: pa_ci_list_v is replaced with the base table pa_control_items and
56: included table hz_parties to get the owner name.
57: 26-Apr-07 vvjoshi Bug#5962401:Modified set_workflow_attributes procedure to set expiration date for adhoc role.
58: 25-Jun-07 rballamu Bug#6053648:Modified change_status_approved to initialize the application context.
59: 17-8-09 anuragar Bug 8566495 Changes for E&C enchancement.
60: 25-9-09 anuragar Bug 8942843 Passing attributes pertaining to PAWFCISC only
868: -- select party_name from
869: --(
870: select hp.party_name
871: from fnd_user fu,
872: hz_parties hp
873: where fu.user_name = l_forward_to --fnd_global.user_id
874: and fu.employee_id is null
875: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
876: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
876: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
877: union
878: select hp.party_name
879: from fnd_user fu,
880: hz_parties hp
881: where fu.user_name = l_forward_to--fnd_global.user_id
882: and fu.employee_id is not null
883: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
884: and 'PER:' || fu.employee_id = hp.orig_system_reference;
1506: pci.owner_id,
1507: hzp.party_name
1508: from pa_control_items pci,
1509: pa_project_statuses pps,
1510: hz_parties hzp
1511: where pci.ci_id = p_ci_id AND
1512: pci.status_code=pps.project_status_code AND
1513: hzp.party_id = pci.owner_id;
1514:
1523: --select user_name, party_name, email_address
1524: --from (
1525: select fu.user_name, hp.party_name, hp.email_address
1526: from fnd_user fu,
1527: hz_parties hp
1528: where
1529: fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
1530: and hp.party_id = c_owner_id
1531: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
1532: union
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)
2790: select ppe.element_number task_number,ppe.name task_name,ppe.description description,
2791: pvsch.scheduled_start_date start_date,pvsch.scheduled_finish_date finish_date,
2792: hz.party_name approver_name
2793: from pa_proj_elements ppe,pa_proj_element_versions ppev,
2794: pa_proj_elem_ver_schedule pvsch,fnd_user fu, hz_parties hz
2795: where ppe.proj_element_id = ppev.proj_element_id
2796: and pvsch.element_version_id = ppev.element_version_id
2797: and ppe.task_approver_id=fu.user_id
2798: and fu.person_party_id=hz.party_id