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 1983: -- select 'Y' FROM dual

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

Line 1991: select 'Y' FROM dual

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

Line 2181: SELECT 'Y' FROM dual

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

Line 2211: -- select 'Y' FROM dual

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

Line 2220: select 'Y' FROM dual

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