APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 36: from pa_project_asset_assignments ppaa

32:
33: /* Bug 7524772: Broke this cursor into two cursors based on the condition IPA_ASSET_MECH_APIS_PKG.g_nl_installed to facilitate proper index to be picked up*/
34: /* cursor get_project_asset_id is
35: select project_asset_id
36: from pa_project_asset_assignments ppaa
37: where ppaa.task_id = p_task_id
38: and ppaa.project_id = p_project_id
39: and nvl(ppaa.attribute8,'~!@#') = nvl(p_attribute8,'~!@#')
40: and nvl(ppaa.attribute9,'~!@#') = nvl(p_attribute9,'~!@#')

Line 54: from pa_project_asset_assignments ppaa

50: End Bug fix:2956569 */
51:
52: cursor get_project_asset_id_nl_ins is
53: select project_asset_id
54: from pa_project_asset_assignments ppaa
55: where ppaa.task_id = p_task_id
56: and ppaa.project_id = p_project_id
57: AND nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
58: AND nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number

Line 66: from pa_project_asset_assignments ppaa

62: ;
63:
64: cursor get_project_asset_id_no_ins is
65: select project_asset_id
66: from pa_project_asset_assignments ppaa
67: where ppaa.task_id = p_task_id
68: and ppaa.project_id = p_project_id
69: and nvl(ppaa.attribute8,'~!@#') = nvl(p_attribute8,'~!@#')
70: and nvl(ppaa.attribute9,'~!@#') = nvl(p_attribute9,'~!@#')