APPS.CST_REVENUECOGSMATCH_PVT dependencies on CST_PAC_PERIODS

Line 5701: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;

5697: l_offset pls_integer;
5698: l_org_code CST_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
5699: l_cost_type CST_COST_TYPES.COST_TYPE%TYPE;
5700: l_cost_group CST_COST_GROUPS.COST_GROUP%TYPE;
5701: l_period_name CST_PAC_PERIODS.PERIOD_NAME%TYPE;
5702: l_meaning FND_LOOKUPS.MEANING%TYPE;
5703: l_stmt_num number;
5704:
5705: l_uLog constant boolean := (fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND fnd_log.test(fnd_log.LEVEL_UNEXPECTED, l_module);

Line 5802: FROM cst_pac_periods

5798: WHERE cost_group_id = i_pac_cost_group;
5799:
5800: SELECT period_name
5801: INTO l_period_name
5802: FROM cst_pac_periods
5803: WHERE pac_period_id = TO_NUMBER(i_period_name);
5804:
5805: SELECT meaning
5806: INTO l_meaning

Line 6473: CST_PAC_PERIODS CPP,

6469: CST_COGS_EVENTS CCE,
6470: OE_ORDER_LINES_ALL OOL,
6471: OE_ORDER_HEADERS_ALL OOH,
6472: CST_COST_GROUP_ASSIGNMENTS CCGA,
6473: CST_PAC_PERIODS CPP,
6474: CST_AE_HEADERS CAH,
6475: CST_AE_LINES CAL
6476: WHERE
6477: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high

Line 6508: CST_PAC_PERIODS CPP

6504: gl_code_combinations_kfv dcogs_acct,
6505: ra_customer_trx_lines_all srclines,
6506: HZ_CUST_ACCOUNTS cust_acct,
6507: cst_cogs_events cce1,
6508: CST_PAC_PERIODS CPP
6509: WHERE
6510: MSI.INVENTORY_ITEM_ID = Q.INVENTORY_ITEM_ID
6511: AND MSI.ORGANIZATION_ID = Q.ORGANIZATION_ID
6512: AND cogs_acct.code_combination_id = Q.cogs_acct_id

Line 6560: cst_pac_periods cpp,

6556: Z.COGS_account cogs_account,
6557: Z.Deferred_COGS_account deferred_cogs_account
6558: FROM
6559: Z,
6560: cst_pac_periods cpp,
6561: ra_cust_trx_line_gl_dist_all dist,
6562: ra_customer_trx_lines_all lines,
6563: ra_customer_trx_all trx
6564: WHERE (Z.customer_trx_line_id = lines.customer_trx_line_id

Line 6646: , CST_PAC_PERIODS CPP

6642: AND NOT EXISTS
6643: (SELECT NULL
6644: FROM ra_customer_trx_lines_all ctl
6645: , ra_cust_trx_line_gl_dist_all ctlgd
6646: , CST_PAC_PERIODS CPP
6647: WHERE (Z.customer_trx_line_id = ctl.customer_trx_line_id
6648: OR Z.customer_trx_line_id = ctl.previous_customer_trx_line_id)
6649: AND CPP.PAC_PERIOD_ID = TO_NUMBER(:i_period_name)
6650: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id