APPS.AMW_CREATE_LINES_PKG dependencies on AMW_CURR_APP_HIERARCHY_ORG_V

Line 724: from AMW_curr_app_HIERARCHY_ORG_V

720: and a.organization_id = p_pk1 --organizationId
721: and a.end_date is null
722: and a.approval_status <> 'A'
723: and a.process_id in (select child_process_id
724: from AMW_curr_app_HIERARCHY_ORG_V
725: where parent_process_id=p_pk2
726: and child_organization_id=p_pk1);
727: */
728: ---02.17.2004 npanandi: cursor to get processes for AddProcess lineType

Line 749: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD

745: ,ALR.DESCRIPTION
746: ,ALR.PROCESS_CODE
747: --,alr.revision_number
748: FROM amw_latest_rev_org_v ALR
749: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD
750: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
751: and alr.ORGANIZATION_ID=p_pk1 --organizationId
752: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId
753: AND APHD.parent_PROCESS_ID=p_pk2; --processId

Line 764: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD

760: ,ALR.DESCRIPTION
761: ,ALR.PROCESS_CODE
762: --,alr.revision_number
763: FROM amw_latest_rev_org_v ALR
764: ,AMW_CURR_APP_HIERARCHY_ORG_V APHD
765: WHERE APHD.CHILD_process_ID=ALR.PROCESS_ID
766: and alr.ORGANIZATION_ID=p_pk1 --organizationId
767: and aphd.CHILD_ORGANIZATION_ID=p_pk1 --organizationId
768: AND APHD.parent_PROCESS_ID=p_pk2 --processId

Line 1047: from amw_curr_app_hierarchy_org_v

1043: ---there may be an immediate child Process, which is also in Draft status
1044: ---in this case, the DeleteProcess Cursor's 'minus' clause causes problems in
1045: ---revisionNumber data, and incorrect resultSet is obtained.
1046: select child_revision_number into l_revision_number
1047: from amw_curr_app_hierarchy_org_v
1048: where child_organization_id=p_pk1 --organizationId
1049: and parent_process_id=p_pk2 --parentProcessId
1050: and child_process_id=delete_proc_rec.process_id; --childProcessId;
1051: