APPS.RCI_OPEN_ISSUE_SUMM_PKG dependencies on FII_TIME_DAY

Line 163: fii_time_day ftd

159: AMW_FIN_PROC_CERT_RELAN afpcr,
160: amw_certification_b proc_cert,
161: amw_certification_b fin_cert,
162: amw_gl_periods_v agpv,
163: fii_time_day ftd
164: where change_order_type_id in (select change_order_type_id
165: from eng_change_order_types
166: where type_classification='HEADER'
167: and change_mgmt_type_code='AMW_PROC_CERT_ISSUES')

Line 289: ,fii_time_day ftd

285: from AMW_CERTIFICATION_B cert
286: ,AMW_FIN_PROC_CERT_RELAN rln
287: ,AMW_CERTIFICATION_B cert2
288: ,amw_gl_periods_v agpv
289: ,fii_time_day ftd
290: where cert.OBJECT_TYPE = 'PROCESS'
291: and rln.PROC_CERT_ID=cert.CERTIFICATION_ID
292: and rln.END_DATE IS NULL
293: and rln.fin_stmt_cert_id = cert2.certification_id

Line 855: from fii_time_day

851: IF(p_param(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_FROM' AND
852: p_param(i).parameter_id is NOT null) THEN
853: select distinct last_day(to_date(to_char(ent_period_end_date,'YYYYMM'),'YYYYMM'))
854: into l_end_date
855: from fii_time_day
856: where ent_period_id=p_param(i).parameter_id;
857:
858: select min(distinct last_day(to_date(to_char(ent_period_start_date,'YYYYMM'),'YYYYMM')))
859: into l_start_date /*gives in the form 30-SEP-06*/

Line 860: from fii_time_day

856: where ent_period_id=p_param(i).parameter_id;
857:
858: select min(distinct last_day(to_date(to_char(ent_period_start_date,'YYYYMM'),'YYYYMM')))
859: into l_start_date /*gives in the form 30-SEP-06*/
860: from fii_time_day
861: where ent_period_id=p_param(i).parameter_id;
862:
863: l_query3 := l_query3 ||' and eec.initiation_date < to_date('''||l_end_date||''',''DD-MON-YYYY'')
864: and (eec.status_code not in (0,11)

Line 873: from fii_time_day

869: IF(p_param(i).parameter_name = 'TIME+FII_TIME_ENT_QTR_FROM' AND
870: p_param(i).parameter_id is NOT null) THEN
871: select distinct last_day(to_date(to_char(ent_qtr_end_date,'YYYYMM'),'YYYYMM'))
872: into l_end_date
873: from fii_time_day
874: where ent_qtr_id=p_param(i).parameter_id;
875:
876: select min(distinct last_day(to_date(to_char(ent_qtr_start_date,'YYYYMM'),'YYYYMM')))
877: into l_start_date /*gives in the form 30-SEP-06*/

Line 878: from fii_time_day

874: where ent_qtr_id=p_param(i).parameter_id;
875:
876: select min(distinct last_day(to_date(to_char(ent_qtr_start_date,'YYYYMM'),'YYYYMM')))
877: into l_start_date /*gives in the form 30-SEP-06*/
878: from fii_time_day
879: where ent_qtr_id=p_param(i).parameter_id;
880:
881: l_query3 := l_query3 ||' and eec.initiation_date < to_date('''||l_end_date||''',''DD-MON-YYYY'')
882: and (eec.status_code not in (0,11)

Line 891: from fii_time_day

887: IF(p_param(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_FROM' AND
888: p_param(i).parameter_id is NOT null) THEN
889: select min(distinct last_day(to_date(to_char(ent_year_end_date,'YYYYMM'),'YYYYMM')))
890: into l_end_date /*gives in the form 30-SEP-06*/
891: from fii_time_day
892: where ent_year_id=p_param(i).parameter_id;
893:
894: select min(distinct last_day(to_date(to_char(ent_year_start_date,'YYYYMM'),'YYYYMM')))
895: into l_start_date /*gives in the form 30-SEP-06*/

Line 896: from fii_time_day

892: where ent_year_id=p_param(i).parameter_id;
893:
894: select min(distinct last_day(to_date(to_char(ent_year_start_date,'YYYYMM'),'YYYYMM')))
895: into l_start_date /*gives in the form 30-SEP-06*/
896: from fii_time_day
897: where ent_year_id=p_param(i).parameter_id;
898:
899: l_query3 := l_query3 ||' and eec.initiation_date < to_date('''||l_end_date||''',''DD-MON-YYYY'')
900: and (eec.status_code not in (0,11)