APPS.PER_QH_FIND_QUERY dependencies on PO_HEADERS_ALL

Line 34: ,po_header_num po_headers_all.segment1%TYPE default null

30: ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
33: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
34: ,po_header_num po_headers_all.segment1%TYPE default null
35: ,po_header_id po_headers_all.po_header_id%TYPE default null
36: ,po_line_num po_lines_all.line_num%TYPE default null
37: ,po_line_id po_lines_all.po_line_id%TYPE default null
38: --

Line 35: ,po_header_id po_headers_all.po_header_id%TYPE default null

31: ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
32: ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
33: ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
34: ,po_header_num po_headers_all.segment1%TYPE default null
35: ,po_header_id po_headers_all.po_header_id%TYPE default null
36: ,po_line_num po_lines_all.line_num%TYPE default null
37: ,po_line_id po_lines_all.po_line_id%TYPE default null
38: --
39: ,first_name per_all_people_f.first_name%type default null

Line 381: from po_headers_all

377: where vendor_site_id=p_vendor_site_id;
378: --
379: cursor csr_po_header(p_po_header_id in number) is
380: select segment1
381: from po_headers_all
382: where po_header_id = p_po_header_id;
383: --
384: cursor csr_po_line(p_po_line_id in number) is
385: select line_num

Line 1017: l_from_clause:=l_from_clause||',po_headers_all poh';

1013: if po_header_id is not null then
1014: l_where_clause:=l_where_clause||' and per_asg.po_header_id='||po_header_id;
1015: l_asg:=TRUE;
1016: elsif po_header_num is not null then
1017: l_from_clause:=l_from_clause||',po_headers_all poh';
1018: l_where_clause:=l_where_clause||' and per_asg.po_header_id=poh.po_header_id'
1019: ||' and upper(poh.segment1) like ('''||upper(replace(po_header_num,g_quote,g_quote||g_quote))||''')';
1020: l_asg:=TRUE;
1021: end if;

Line 2476: ,po_header_num in po_headers_all.segment1%TYPE default null

2472: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2476: ,po_header_num in po_headers_all.segment1%TYPE default null
2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2478: ,po_line_num in po_lines_all.line_num%TYPE default null
2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2480: --

Line 2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null

2473: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2474: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2475: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2476: ,po_header_num in po_headers_all.segment1%TYPE default null
2477: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2478: ,po_line_num in po_lines_all.line_num%TYPE default null
2479: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2480: --
2481: ,first_name in per_all_people_f.first_name%type default null