APPS.RCI_ORG_CERT_SUMM_PKG dependencies on STANDARD

Line 1335: and ropdf.standard_process_flag = fl2.lookup_code

1331: where ropdf.process_id = alrv.process_id
1332: and ropdf.organization_id = aauv.organization_id
1333: and ropdf.significant_process_flag = fl1.lookup_code
1334: and fl1.lookup_type = ''YES_NO''
1335: and ropdf.standard_process_flag = fl2.lookup_code
1336: and fl2.lookup_type = ''YES_NO''
1337: and ropdf.fin_certification_id = acv.certification_id
1338: /**and acv.object_type = ''PROCESS''**/
1339: and nvl(ropdf.certification_result_code,''NOT_CERTIFIED'') = rbcrv.id(+)

Line 1718: and rpdf.standard_process_flag = al2.lookup_code

1714: and rpdf.organization_id = apov.organization_id
1715: and rpdf.organization_id = aauv.organization_id
1716: and rpdf.significant_process_flag = al1.lookup_code
1717: and al1.lookup_type = ''AMW_SIGNIFICANT_PROCESS''
1718: and rpdf.standard_process_flag = al2.lookup_code
1719: and al2.lookup_type = ''AMW_STANDARD_PROCESS''
1720: and rpdf.process_category = al3.lookup_code(+)
1721: and al3.lookup_type(+) = ''AMW_PROCESS_CATEGORY''
1722: and rpdf.fin_certification_id = acv.certification_id

Line 1719: and al2.lookup_type = ''AMW_STANDARD_PROCESS''

1715: and rpdf.organization_id = aauv.organization_id
1716: and rpdf.significant_process_flag = al1.lookup_code
1717: and al1.lookup_type = ''AMW_SIGNIFICANT_PROCESS''
1718: and rpdf.standard_process_flag = al2.lookup_code
1719: and al2.lookup_type = ''AMW_STANDARD_PROCESS''
1720: and rpdf.process_category = al3.lookup_code(+)
1721: and al3.lookup_type(+) = ''AMW_PROCESS_CATEGORY''
1722: and rpdf.fin_certification_id = acv.certification_id
1723: /**01.25.2006 npanandi: bug 5000369 fix**/