APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_PAC_PERIODS

Line 5585: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;

5581: l_offset pls_integer;
5582: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
5583: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
5584: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;
5585: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5586: l_meaning FND_LOOKUPS.MEANING%TYPE;
5587: l_stmt_num number;
5588:
5589: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);

Line 5685: FROM cst_pac_periods

5681: WHERE cost_group_id = i_pac_cost_group;
5682:
5683: SELECT period_name
5684: INTO l_period_name
5685: FROM cst_pac_periods
5686: WHERE pac_period_id = TO_NUMBER(i_period_name);
5687:
5688: SELECT meaning
5689: INTO l_meaning

Line 6184: CST_PAC_PERIODS CPP,

6180: CST_COGS_EVENTS CCE,
6181: OE_ORDER_LINES_ALL OOL,
6182: OE_ORDER_HEADERS_ALL OOH,
6183: CST_COST_GROUP_ASSIGNMENTS CCGA,
6184: CST_PAC_PERIODS CPP,
6185: CST_AE_HEADERS CAH,
6186: CST_AE_LINES CAL
6187: WHERE
6188: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high

Line 6268: cst_pac_periods cpp,

6264: Z.COGS_account cogs_account,
6265: Z.Deferred_COGS_account deferred_cogs_account
6266: FROM
6267: Z,
6268: cst_pac_periods cpp,
6269: ra_cust_trx_line_gl_dist_all dist,
6270: ra_customer_trx_lines_all lines,
6271: ra_customer_trx_all trx
6272: WHERE (Z.customer_trx_line_id = lines.customer_trx_line_id