APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_TIME_BSNS_QTR_V

Line 453: from DDR_TIME_BSNS_QTR_V

449: /* Populate DDR_R_QTR_TRANS table */
450: delete from DDR_R_QTR_TRANS
451: where (QTR_CD,CLNDR_CD) in (
452: select QTR_CD,CLNDR_CD
453: from DDR_TIME_BSNS_QTR_V
454: where ORG_CD = p_org_cd
455: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
456: );
457:

Line 508: DDR_TIME_BSNS_QTR_V QTR,

504: g_last_updated_by,
505: g_last_update_date,
506: g_last_update_login
507: from
508: DDR_TIME_BSNS_QTR_V QTR,
509: DDR_TIME_BSNS_QTR_V PQTR,
510: DDR_TIME_BSNS_QTR_V PYR,
511: DDR_TIME_BSNS_QTR_V NQTR,
512: DDR_TIME_BSNS_QTR_V NYR

Line 509: DDR_TIME_BSNS_QTR_V PQTR,

505: g_last_update_date,
506: g_last_update_login
507: from
508: DDR_TIME_BSNS_QTR_V QTR,
509: DDR_TIME_BSNS_QTR_V PQTR,
510: DDR_TIME_BSNS_QTR_V PYR,
511: DDR_TIME_BSNS_QTR_V NQTR,
512: DDR_TIME_BSNS_QTR_V NYR
513: where QTR.ORG_CD = p_org_cd

Line 510: DDR_TIME_BSNS_QTR_V PYR,

506: g_last_update_login
507: from
508: DDR_TIME_BSNS_QTR_V QTR,
509: DDR_TIME_BSNS_QTR_V PQTR,
510: DDR_TIME_BSNS_QTR_V PYR,
511: DDR_TIME_BSNS_QTR_V NQTR,
512: DDR_TIME_BSNS_QTR_V NYR
513: where QTR.ORG_CD = p_org_cd
514: and QTR.YR_CD between to_char(p_start_year) and to_char(p_end_year)

Line 511: DDR_TIME_BSNS_QTR_V NQTR,

507: from
508: DDR_TIME_BSNS_QTR_V QTR,
509: DDR_TIME_BSNS_QTR_V PQTR,
510: DDR_TIME_BSNS_QTR_V PYR,
511: DDR_TIME_BSNS_QTR_V NQTR,
512: DDR_TIME_BSNS_QTR_V NYR
513: where QTR.ORG_CD = p_org_cd
514: and QTR.YR_CD between to_char(p_start_year) and to_char(p_end_year)
515: and PQTR.ORG_CD(+) = QTR.ORG_CD

Line 512: DDR_TIME_BSNS_QTR_V NYR

508: DDR_TIME_BSNS_QTR_V QTR,
509: DDR_TIME_BSNS_QTR_V PQTR,
510: DDR_TIME_BSNS_QTR_V PYR,
511: DDR_TIME_BSNS_QTR_V NQTR,
512: DDR_TIME_BSNS_QTR_V NYR
513: where QTR.ORG_CD = p_org_cd
514: and QTR.YR_CD between to_char(p_start_year) and to_char(p_end_year)
515: and PQTR.ORG_CD(+) = QTR.ORG_CD
516: and PQTR.CLNDR_CD(+) = QTR.CLNDR_CD

Line 784: from DDR_TIME_BSNS_QTR_V

780: /* Populate DDR_R_QTR_TODATE_TRANS table */
781: delete from DDR_R_QTR_TODATE_TRANS
782: where (QTR_CD,CLNDR_CD) in (
783: select QTR_CD,CLNDR_CD
784: from DDR_TIME_BSNS_QTR_V
785: where ORG_CD = p_org_cd
786: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
787: );
788:

Line 834: FROM DDR_TIME_BSNS_QTR_V A,

830: A.QTR_ID QTR_ID,
831: A.CLNDR_CD CLNDR_CD,
832: B.QTR_CD YR_QTR_CD,
833: B.QTR_ID YR_QTR_ID
834: FROM DDR_TIME_BSNS_QTR_V A,
835: DDR_TIME_BSNS_QTR_V B
836: WHERE A.YR_CD = B.YR_CD
837: AND A.QTR_CD >= B.QTR_CD
838: AND A.ORG_CD = B.ORG_CD

Line 835: DDR_TIME_BSNS_QTR_V B

831: A.CLNDR_CD CLNDR_CD,
832: B.QTR_CD YR_QTR_CD,
833: B.QTR_ID YR_QTR_ID
834: FROM DDR_TIME_BSNS_QTR_V A,
835: DDR_TIME_BSNS_QTR_V B
836: WHERE A.YR_CD = B.YR_CD
837: AND A.QTR_CD >= B.QTR_CD
838: AND A.ORG_CD = B.ORG_CD
839: AND A.ORG_CD = p_org_cd