APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

Line 4454: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(

4450: FND_DSQL.add_bind(l_start_date);
4451: FND_DSQL.add_text(' and ');
4452: FND_DSQL.add_bind(l_end_date);
4453: FND_DSQL.add_text(' AND inventory_item_id IN (SELECT s.product_id FROM ( ');
4454: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(
4455: p_context => l_product_attr_context,
4456: p_attribute => l_product_attribute,
4457: p_attr_value_from => l_product_attr_value,
4458: p_attr_value_to => NULL,

Line 4575: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(

4571: FND_DSQL.add_bind(l_start_date);
4572: FND_DSQL.add_text(' and ');
4573: FND_DSQL.add_bind(l_end_date);
4574: FND_DSQL.add_text(' AND inventory_item_id IN (SELECT s.product_id FROM ( ');
4575: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql(
4576: p_context => l_product_attr_context,
4577: p_attribute => l_product_attribute,
4578: p_attr_value_from => l_product_attr_value,
4579: p_attr_value_to => NULL,