APPS.CST_PENDINGTXNSREPORT_PVT dependencies on ORG_ACCT_PERIODS

Line 91: FROM org_acct_periods

87:
88: l_stmt_num := 10;
89: SELECT period_start_date, schedule_close_date
90: INTO l_period_start_date, l_period_end_date
91: FROM org_acct_periods
92: WHERE acct_period_id = p_period_id
93: AND organization_id = p_org_id;
94:
95: l_stmt_num := 15;

Line 475: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;

471: l_ctx NUMBER;
472: l_xml_temp CLOB;
473: l_offset PLS_INTEGER;
474: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
475: l_period_name ORG_ACCT_PERIODS.PERIOD_NAME%TYPE;
476: l_resolution_type MFG_LOOKUPS.MEANING%TYPE;
477: l_temp VARCHAR2(240);
478: l_stmt_num NUMBER;
479:

Line 525: FROM org_acct_periods

521:
522: l_stmt_num := 20;
523: SELECT PERIOD_NAME
524: INTO l_period_name
525: FROM org_acct_periods
526: WHERE acct_period_id = i_period_id
527: AND organization_id = i_org_id;
528:
529: l_stmt_num := 25;