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

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

Line 1106: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='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

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

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

Line 1120: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAO.ORGANIZATION_ID))='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

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

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

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

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;