DBA Data[Home] [Help]

APPS.PO_POXSERPR_XMLP_PKG dependencies on HR_GENERAL

Line 122: AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id

118: SELECT nvl(max(fsp.business_group_id),0)
119: FROM financials_system_parameters fsp)
120: AND trunc(sysdate) BETWEEN
121: papf.effective_start_date and papf.effective_end_date
122: AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id
123: , hr_general.get_business_group_id) = papf.business_group_id
124: AND papf.full_name = nvl(P_BUYER,papf.full_name);
125:
126: l_buyer_where_h := 'AND poh.agent_id = ' || l_person_id;

Line 123: , hr_general.get_business_group_id) = papf.business_group_id

119: FROM financials_system_parameters fsp)
120: AND trunc(sysdate) BETWEEN
121: papf.effective_start_date and papf.effective_end_date
122: AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id
123: , hr_general.get_business_group_id) = papf.business_group_id
124: AND papf.full_name = nvl(P_BUYER,papf.full_name);
125:
126: l_buyer_where_h := 'AND poh.agent_id = ' || l_person_id;
127: l_buyer_where_r := 'AND por.agent_id = ' || l_person_id;