DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on QP_LIST_HEADERS_B

Line 3133: l_table_name := 'QP_LIST_HEADERS_B';

3129: l_pk_name := 'CAMPAIGN_ID';
3130: -- 02/23/2001 mpande ADDED for Hornet reqmt
3131: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'OFFR'
3132: OR p_act_budgets_rec.arc_act_budget_used_by = 'PRIC' THEN -- yzhao: 10/20/2003 added for price list
3133: l_table_name := 'QP_LIST_HEADERS_B';
3134: l_pk_name := 'LIST_HEADER_ID';
3135: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'WKST' THEN
3136: l_table_name := 'OZF_WORKSHEET_HEADERS_VL';
3137: l_pk_name := 'WORKSHEET_HEADER_ID';

Line 3216: l_table_name := 'QP_LIST_HEADERS_B';

3212: /* 07/27/2001 yzhao ADDED for Hornet reqmt
3213: 10/24/2003 yzhao ADDED for PRIC */
3214: ELSIF p_act_budgets_rec.budget_source_type = 'OFFR'
3215: OR p_act_budgets_rec.budget_source_type = 'PRIC' THEN
3216: l_table_name := 'QP_LIST_HEADERS_B';
3217: l_pk_name := 'LIST_HEADER_ID';
3218: ELSIF p_act_budgets_rec.owner_id IS NOT NULL or
3219: p_act_budgets_rec.owner_id <> FND_API.g_miss_num THEN
3220: l_table_name := 'ams_jtf_rs_emp_v';

Line 4416: FROM qp_list_headers_b

4412: WHERE qp_list_header_id = p_object_id;
4413:
4414: CURSOR c_pricelist IS
4415: SELECT currency_code
4416: FROM qp_list_headers_b
4417: WHERE list_header_id = p_object_id;
4418:
4419: CURSOR c_worksheet IS
4420: SELECT currency_code