APPS.CST_PENDINGTXNSREPORT_PVT dependencies on ORG_ACCT_PERIODS

Line 90: FROM org_acct_periods

86:
87: l_stmt_num := 10;
88: SELECT period_start_date, schedule_close_date
89: INTO l_period_start_date, l_period_end_date
90: FROM org_acct_periods
91: WHERE acct_period_id = p_period_id
92: AND organization_id = p_org_id;
93:
94: /* Initialize message stack */

Line 461: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;

457: l_ctx NUMBER;
458: l_xml_temp CLOB;
459: l_offset PLS_INTEGER;
460: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
461: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;
462: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;
463: l_temp VARCHAR2(240);
464: l_stmt_num NUMBER;
465:

Line 511: FROM org_acct_periods

507:
508: l_stmt_num := 20;
509: SELECT PERIOD_NAME
510: INTO l_period_name
511: FROM org_acct_periods
512: WHERE acct_period_id = i_period_id
513: AND organization_id = i_org_id;
514:
515: l_stmt_num := 25;