APPS.PQH_WKS_BUDGET dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1106: from hr_all_organization_units

1102: from pqh_budgets bgt, pqh_budget_versions bgv
1103: where bgv.budget_id = bgt.budget_id
1104: and bgv.budget_version_id = p_budget_version_id;
1105: cursor c1 is select organization_id
1106: from hr_all_organization_units
1107: where business_group_id = p_business_group_id
1108: and date_from < l_budget_end_date
1109: and (date_to > l_budget_start_date or date_to is null)
1110: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',

Line 1111: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'

1107: where business_group_id = p_business_group_id
1108: and date_from < l_budget_end_date
1109: and (date_to > l_budget_start_date or date_to is null)
1110: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1111: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'
1112: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id
1113: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1114: cursor c2 is select w.organization_id_child organization_id
1115: from pqh_worksheet_organizations_v w

Line 1120: from hr_all_organization_units hao

1116: where org_structure_version_id = p_org_hier_ver
1117: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'
1118: and exists
1119: (select null
1120: from hr_all_organization_units hao
1121: where organization_id = w.organization_id_child
1122: and date_from < l_budget_end_date
1123: and (date_to > l_budget_start_date or date_to is null)
1124: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',

Line 1125: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' )

1121: where organization_id = w.organization_id_child
1122: and date_from < l_budget_end_date
1123: and (date_to > l_budget_start_date or date_to is null)
1124: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1125: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' )
1126: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id) = hao.business_group_id)
1127: connect by prior organization_id_child = organization_id_parent
1128: and org_structure_version_id = p_org_hier_ver
1129: start with organization_id_parent = p_start_organization_id

Line 1133: from hr_all_organization_units hao

1129: start with organization_id_parent = p_start_organization_id
1130: and org_structure_version_id = p_org_hier_ver
1131: union
1132: select organization_id
1133: from hr_all_organization_units hao
1134: where organization_id = p_start_organization_id
1135: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'
1136: and date_from < l_budget_end_date
1137: and (date_to > l_budget_start_date or date_to is null)

Line 1139: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;

1135: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'
1136: and date_from < l_budget_end_date
1137: and (date_to > l_budget_start_date or date_to is null)
1138: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1139: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;
1140: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id ,
1141: -- hr_general.get_business_group_id) = hao.business_group_id;
1142:
1143: l_budget_detail_id number;

Line 1498: l_org_name hr_all_organization_units.name%type;

1494: raise;
1495: END;
1496: function get_transaction_name(p_worksheet_detail_id in number) return varchar2 is
1497: l_worksheet_name varchar2(240);
1498: l_org_name hr_all_organization_units.name%type;
1499: l_org_id number;
1500: l_transaction_name varchar2(300);
1501: cursor c1 is
1502: select wks.worksheet_name,wkd.organization_id