APPS.PER_QH_FIND_QUERY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 61: ,assignment_status_type per_assignment_status_types.user_status%type default null

57: ,position hr_all_positions_f.name%type default null
58: ,position_id per_all_assignments_f.position_id%type default null
59: ,job per_jobs.name%type default null
60: ,job_id per_all_assignments_f.job_id%type default null
61: ,assignment_status_type per_assignment_status_types.user_status%type default null
62: ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
63: ,payroll pay_all_payrolls_f.payroll_name%type default null
64: ,payroll_id per_all_assignments_f.payroll_id%type default null
65: ,location hr_locations.location_code%type default null

Line 254: per_assignment_status_types_tl stl,

250: nvl(a.per_system_status ,s.per_system_status)
251: FROM
252: per_ass_status_type_amends_tl atl,
253: per_ass_status_type_amends a,
254: per_assignment_status_types_tl stl,
255: per_assignment_status_types s
256: WHERE
257: s.assignment_status_type_id=p_assignment_status_type_id and
258: a.assignment_status_type_id (+)=s.assignment_status_type_id and

Line 255: per_assignment_status_types s

251: FROM
252: per_ass_status_type_amends_tl atl,
253: per_ass_status_type_amends a,
254: per_assignment_status_types_tl stl,
255: per_assignment_status_types s
256: WHERE
257: s.assignment_status_type_id=p_assignment_status_type_id and
258: a.assignment_status_type_id (+)=s.assignment_status_type_id and
259: a.business_group_id (+) = s.business_group_id and

Line 700: ,'per_assignment_status_types s_a,per_assignment_status_types_tl stl_a,per_ass_status_type_amends a_a,per_ass_status_type_amends_tl atl_a'

696: --Modified for PMxbg
697: l_a_where_clause:=build_varchar2_where('per_asg.assignment_status_type_id'
698: ,p_condition
699: ,p_value
700: ,'per_assignment_status_types s_a,per_assignment_status_types_tl stl_a,per_ass_status_type_amends a_a,per_ass_status_type_amends_tl atl_a'
701: ,'s_a.assignment_status_type_id'
702: ,'nvl(atl_a.user_status,stl_a.user_status)'
703: ,' and a_a.assignment_status_type_id (+)=s_a.assignment_status_type_id'
704: ||' and s_a.assignment_status_type_id=stl_a.assignment_status_type_id'

Line 1088: l_from_clause:=l_from_clause||',per_assignment_status_types s,per_assignment_status_types_tl stl';

1084: if assignment_status_type_id is not null then
1085: l_where_clause:=l_where_clause||' and per_asg.assignment_status_type_id='||assignment_status_type_id;
1086: l_asg:=TRUE;
1087: elsif assignment_status_type is not null then
1088: l_from_clause:=l_from_clause||',per_assignment_status_types s,per_assignment_status_types_tl stl';
1089: l_from_clause:=l_from_clause||',per_ass_status_type_amends a,per_ass_status_type_amends_tl atl';
1090: l_where_clause:=l_where_clause||' and upper(nvl(atl.user_status,stl.user_status))'
1091: ||' like ('''||upper(replace(assignment_status_type,g_quote,g_quote||g_quote))||''')'
1092: ||' and s.assignment_status_type_id=per_asg.assignment_status_type_id'

Line 2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null

2499: ,position in hr_all_positions_f.name%type default null
2500: ,position_id in per_all_assignments_f.position_id%type default null
2501: ,job in per_jobs.name%type default null
2502: ,job_id in per_all_assignments_f.job_id%type default null
2503: ,assignment_status_type in per_assignment_status_types.user_status%type default null
2504: ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
2505: ,payroll in pay_all_payrolls_f.payroll_name%type default null
2506: ,payroll_id in per_all_assignments_f.payroll_id%type default null
2507: ,location in hr_locations.location_code%type default null