APPS.PA_PROGRESS_REPORT_PVT dependencies on DUAL

Line 144: -- FROM dual;

140:
141: -- IF p_record_sequence IS NULL THEN
142: -- SELECT pa_object_page_versions_s.NEXTVAL
143: -- INTO l_record_sequence
144: -- FROM dual;
145: -- ELSE
146: -- l_record_sequence := p_record_sequence;
147: -- END IF;
148:

Line 1982: -- select 'Y' FROM dual

1978: AND pprv.version_id = p_version_id
1979: AND pprv.object_type = 'PA_PROJECTS';
1980:
1981: -- CURSOR get_wf_status IS
1982: -- select 'Y' FROM dual
1983: -- WHERE exists
1984: -- (SELECT *
1985: -- from wf_item_activity_statuses
1986: -- WHERE item_type = 'PAWFPPRA'

Line 1990: select 'Y' FROM dual

1986: -- WHERE item_type = 'PAWFPPRA'
1987: -- AND item_key = l_item_key
1988: -- AND activity_status = 'ACTIVE');
1989: CURSOR get_wf_status IS
1990: select 'Y' FROM dual
1991: WHERE exists
1992: (SELECT *
1993: from wf_item_activity_statuses wias, pa_project_statuses pps
1994: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE

Line 2180: SELECT 'Y' FROM dual

2176: l_item_type VARCHAR2(30);
2177: l_dummy VARCHAR2(30) := 'N';
2178:
2179: CURSOR check_auto_approve IS
2180: SELECT 'Y' FROM dual
2181: WHERE exists
2182: (
2183: SELECT p1.approval_required
2184: FROM pa_object_page_layouts p1,

Line 2210: -- select 'Y' FROM dual

2206: AND pprv.version_id = p_version_id
2207: AND pprv.object_type = 'PA_PROJECTS';
2208:
2209: -- CURSOR get_wf_status IS
2210: -- select 'Y' FROM dual
2211: -- WHERE exists
2212: -- (SELECT *
2213: -- from wf_item_activity_statuses
2214: -- WHERE item_type = 'PAWFPPRA'

Line 2219: select 'Y' FROM dual

2215: -- AND item_key = l_item_key
2216: -- AND activity_status = 'ACTIVE');
2217:
2218: CURSOR get_wf_status IS
2219: select 'Y' FROM dual
2220: WHERE exists
2221: (SELECT *
2222: from wf_item_activity_statuses wias, pa_project_statuses pps
2223: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE