APPS.AMW_FINSTMT_CERT_PVT dependencies on STANDARD

Line 2073: WHERE varproc.standard_variation = p_process_id

2069: select proc_cert_Id from AMW_FIN_PROC_CERT_RELAN
2070: where fin_stmt_cert_id = p_cert_id)
2071: AND aov.pk1_value in (SELECT varproc.process_id
2072: FROM AMW_PROCESS varproc
2073: WHERE varproc.standard_variation = p_process_id
2074: AND varproc.standard_process_flag = 'N'
2075: AND varproc.process_id in (select distinct evalsum.process_id
2076: from amw_fin_process_eval_sum evalsum
2077: where evalsum.fin_certification_id = p_cert_id)));

Line 2074: AND varproc.standard_process_flag = 'N'

2070: where fin_stmt_cert_id = p_cert_id)
2071: AND aov.pk1_value in (SELECT varproc.process_id
2072: FROM AMW_PROCESS varproc
2073: WHERE varproc.standard_variation = p_process_id
2074: AND varproc.standard_process_flag = 'N'
2075: AND varproc.process_id in (select distinct evalsum.process_id
2076: from amw_fin_process_eval_sum evalsum
2077: where evalsum.fin_certification_id = p_cert_id)));
2078:

Line 2087: WHERE varproc.standard_variation = p_process_id

2083: from amw_fin_process_eval_sum evalsum
2084: where evalsum.fin_certification_id = p_cert_id
2085: and evalsum.process_id in (select varproc.process_id
2086: FROM AMW_PROCESS varproc
2087: WHERE varproc.standard_variation = p_process_id
2088: AND varproc.standard_process_flag = 'N'));
2089: -- end variant process
2090:
2091: l_start_date DATE;

Line 2088: AND varproc.standard_process_flag = 'N'));

2084: where evalsum.fin_certification_id = p_cert_id
2085: and evalsum.process_id in (select varproc.process_id
2086: FROM AMW_PROCESS varproc
2087: WHERE varproc.standard_variation = p_process_id
2088: AND varproc.standard_process_flag = 'N'));
2089: -- end variant process
2090:
2091: l_start_date DATE;
2092: l_end_date DATE;