eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WKS_BUDGET dependencies on HR_SECURITY

Line 1110: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',

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',
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

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 1124: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',

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',
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

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 1138: and DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE',

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)
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:

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;