APPS.PA_ASSET_REVERSAL_PVT dependencies on PA_PROJECT_ASSET_LINES

Line 79: FROM pa_project_asset_lines pal

75:
76:
77: CURSOR seldetailids_cur IS
78: SELECT pal.project_asset_line_detail_id
79: FROM pa_project_asset_lines pal
80: WHERE pal.project_asset_id = p_project_asset_id
81: AND pal.transfer_status_code||'' = 'T'
82: AND pal.rev_proj_asset_line_id is NULL
83: AND NOT EXISTS

Line 85: FROM pa_project_asset_lines ppal

81: AND pal.transfer_status_code||'' = 'T'
82: AND pal.rev_proj_asset_line_id is NULL
83: AND NOT EXISTS
84: ( SELECT 'This Line was adjusted before'
85: FROM pa_project_asset_lines ppal
86: WHERE ppal.rev_proj_asset_line_id = pal.project_asset_line_id
87: )
88: GROUP by project_asset_line_detail_id;
89:

Line 97: FROM pa_project_asset_lines pal

93:
94: --This cursor borrowed from PA_FAXFACE.check_asset_to_be_reversed
95: CURSOR check_asset_line_cur(x_proj_asset_line_detail_id NUMBER) IS
96: SELECT project_asset_id
97: FROM pa_project_asset_lines pal
98: WHERE pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
99: AND NOT EXISTS
100: ( SELECT 'This Line was adjusted before'
101: FROM pa_project_asset_lines ppal

Line 101: FROM pa_project_asset_lines ppal

97: FROM pa_project_asset_lines pal
98: WHERE pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
99: AND NOT EXISTS
100: ( SELECT 'This Line was adjusted before'
101: FROM pa_project_asset_lines ppal
102: WHERE ppal.rev_proj_asset_line_id = pal.project_asset_line_id
103: )
104: AND pal.project_asset_id NOT IN
105: ( SELECT project_asset_id

Line 112: FROM pa_project_asset_lines pal

108: AND pas.project_id = pal.project_id
109: )
110: UNION
111: SELECT project_asset_id
112: FROM pa_project_asset_lines pal
113: WHERE pal.project_asset_line_detail_id = x_proj_asset_line_detail_id
114: AND pal.transfer_status_code <> 'T'
115: AND pal.rev_proj_asset_line_id IS NULL
116: AND pal.project_asset_id IN