APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_BUYERS_VAL_V

Line 2646: FROM po_buyers_val_v

2642: INSERT INTO po_session_gt(key, num1, num2)
2643: SELECT p_key,
2644: p_index_tbl(i),
2645: employee_id
2646: FROM po_buyers_val_v
2647: WHERE x_agent_id_tbl(i) IS NULL
2648: AND p_agent_name_tbl(i) IS NOT NULL
2649: AND full_name = p_agent_name_tbl(i);
2650:

Line 3972: FROM PO_BUYERS_VAL_V

3968: INSERT INTO po_session_gt(key, num1, char1)
3969: SELECT p_key,
3970: p_index_tbl(i),
3971: To_Char(employee_id)
3972: FROM PO_BUYERS_VAL_V
3973: WHERE x_clm_award_administrator_tbl(i) IS NULL
3974: AND p_clm_award_admin_disp_tbl(i) IS NOT null
3975: AND ('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)
3976: AND full_name = p_clm_award_admin_disp_tbl(i);

Line 4041: FROM PO_BUYERS_VAL_V

4037: INSERT INTO po_session_gt(key, num1, num2)
4038: SELECT p_key,
4039: p_index_tbl(i),
4040: employee_id
4041: FROM PO_BUYERS_VAL_V
4042: WHERE x_clm_contract_officer_tbl(i) IS NULL
4043: AND p_clm_contract_oficer_disp_tbl(i) IS NOT null
4044: AND ('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)
4045: AND full_name = p_clm_contract_oficer_disp_tbl(i)