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_UTILITY dependencies on HR_GENERAL

Line 986: Select substr(ppl.full_name||'('||hr_general.decode_lookup('PQH_GEN_LOV','EMP_

982: --
983: l_proc varchar2(72) := g_package||'decode_assignment_name';
984: --
985: Cursor assignment_name is
986: Select substr(ppl.full_name||'('||hr_general.decode_lookup('PQH_GEN_LOV','EMP_
987: NUM')||'='||ppl.employee_number||')',1,240)
988: from per_all_assignments_f asg , per_all_people_f ppl,fnd_sessions ses
989: where asg.assignment_id = p_assignment_id
990: and asg.person_id = ppl.person_id

Line 2079: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','GLOBAL');

2075: l_scope varchar2(1000);
2076: l_oh_name per_organization_structures.name%type;
2077: begin
2078: if p_business_group_id is null then
2079: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','GLOBAL');
2080: else
2081: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','BG')||':'||hr_general.decode_organization(p_business_group_id);
2082: if p_organization_structure_id is not null then
2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;

Line 2081: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','BG')||':'||hr_general.decode_organization(p_business_group_id);

2077: begin
2078: if p_business_group_id is null then
2079: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','GLOBAL');
2080: else
2081: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','BG')||':'||hr_general.decode_organization(p_business_group_id);
2082: if p_organization_structure_id is not null then
2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;
2084: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','OH')||':'||l_oh_name;
2085: if p_starting_organization_id is not null then

Line 2084: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','OH')||':'||l_oh_name;

2080: else
2081: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','BG')||':'||hr_general.decode_organization(p_business_group_id);
2082: if p_organization_structure_id is not null then
2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;
2084: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','OH')||':'||l_oh_name;
2085: if p_starting_organization_id is not null then
2086: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','STORG')||':'||hr_general.decode_organization(p_starting_organization_id);
2087: end if;
2088: end if;

Line 2086: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','STORG')||':'||hr_general.decode_organization(p_starting_organization_id);

2082: if p_organization_structure_id is not null then
2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;
2084: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','OH')||':'||l_oh_name;
2085: if p_starting_organization_id is not null then
2086: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','STORG')||':'||hr_general.decode_organization(p_starting_organization_id);
2087: end if;
2088: end if;
2089: if p_organization_id is not null then
2090: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','ORG')||':'||hr_general.decode_organization(p_organization_id);

Line 2090: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','ORG')||':'||hr_general.decode_organization(p_organization_id);

2086: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','STORG')||':'||hr_general.decode_organization(p_starting_organization_id);
2087: end if;
2088: end if;
2089: if p_organization_id is not null then
2090: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','ORG')||':'||hr_general.decode_organization(p_organization_id);
2091: end if;
2092: end if;
2093: return l_scope;
2094: end;