APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

Line 4074: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(

4070: FND_DSQL.add_bind(l_start_date);
4071: FND_DSQL.add_text(' and ');
4072: FND_DSQL.add_bind(l_end_date);
4073: FND_DSQL.add_text(' AND inventory_item_id IN (SELECT s.product_id FROM ( ');
4074: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(
4075: p_context => l_product_attr_context,
4076: p_attribute => l_product_attribute,
4077: p_attr_value_from => l_product_attr_value,
4078: p_attr_value_to => NULL,

Line 4195: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(

4191: FND_DSQL.add_bind(l_start_date);
4192: FND_DSQL.add_text(' and ');
4193: FND_DSQL.add_bind(l_end_date);
4194: FND_DSQL.add_text(' AND inventory_item_id IN (SELECT s.product_id FROM ( ');
4195: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(
4196: p_context => l_product_attr_context,
4197: p_attribute => l_product_attribute,
4198: p_attr_value_from => l_product_attr_value,
4199: p_attr_value_to => NULL,