[Home] [Help]
1097: from pqh_budgets bgt, pqh_budget_versions bgv
1098: where bgv.budget_id = bgt.budget_id
1099: and bgv.budget_version_id = p_budget_version_id;
1100: cursor c1 is select organization_id
1101: from hr_all_organization_units
1102: where business_group_id = p_business_group_id
1103: and date_from < l_budget_end_date
1104: and (date_to > l_budget_start_date or date_to is null)
1105: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1102: where business_group_id = p_business_group_id
1103: and date_from < l_budget_end_date
1104: and (date_to > l_budget_start_date or date_to is null)
1105: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1106: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'
1107: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id
1108: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1109: cursor c2 is select w.organization_id_child organization_id
1110: from pqh_worksheet_organizations_v w
1111: where org_structure_version_id = p_org_hier_ver
1112: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'
1113: and exists
1114: (select null
1115: from hr_all_organization_units hao
1116: where organization_id = w.organization_id_child
1117: and date_from < l_budget_end_date
1118: and (date_to > l_budget_start_date or date_to is null)
1119: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1116: where organization_id = w.organization_id_child
1117: and date_from < l_budget_end_date
1118: and (date_to > l_budget_start_date or date_to is null)
1119: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1120: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' )
1121: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id) = hao.business_group_id)
1122: connect by prior organization_id_child = organization_id_parent
1123: and org_structure_version_id = p_org_hier_ver
1124: start with organization_id_parent = p_start_organization_id
1124: start with organization_id_parent = p_start_organization_id
1125: and org_structure_version_id = p_org_hier_ver
1126: union
1127: select organization_id
1128: from hr_all_organization_units hao
1129: where organization_id = p_start_organization_id
1130: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'
1131: and date_from < l_budget_end_date
1132: and (date_to > l_budget_start_date or date_to is null)
1130: and pqh_budget.already_budgeted_org(p_start_organization_id) = 'FALSE'
1131: and date_from < l_budget_end_date
1132: and (date_to > l_budget_start_date or date_to is null)
1133: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',
1134: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='TRUE' ;
1135: --AND decode(hr_general.get_xbg_profile,'Y', hao.business_group_id ,
1136: -- hr_general.get_business_group_id) = hao.business_group_id;
1137:
1138: l_budget_detail_id number;
1489: raise;
1490: END;
1491: function get_transaction_name(p_worksheet_detail_id in number) return varchar2 is
1492: l_worksheet_name varchar2(240);
1493: l_org_name hr_all_organization_units.name%type;
1494: l_org_id number;
1495: l_transaction_name varchar2(300);
1496: cursor c1 is
1497: select wks.worksheet_name,wkd.organization_id