DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on HR_GENERAL

Line 2899: WHERE('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)

2895: WHERE EXISTS (
2896: SELECT FULL_NAME
2897: FROM
2898: PO_BUYERS_VAL_V
2899: WHERE('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)
2900: AND employee_id = To_Number(p_award_admin_tbl(i))
2901: );
2902: EXCEPTION WHEN No_Data_Found
2903: THEN

Line 2967: WHERE('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)

2963: WHERE EXISTS (
2964: SELECT FULL_NAME
2965: FROM
2966: PO_BUYERS_VAL_V
2967: WHERE('Y' = 'Y' or BUSINESS_GROUP_ID = HR_GENERAL.get_business_group_id)
2968: AND employee_id = p_contract_officer_tbl(i)
2969: AND Nvl(contract_officer,'N') = 'Y'
2970: );
2971: EXCEPTION WHEN No_Data_Found