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 1001: l_from_clause:=l_from_clause||',po_headers_all poh';

997: if po_header_id is not null then
998: l_where_clause:=l_where_clause||' and per_asg.po_header_id='||po_header_id;
999: l_asg:=TRUE;
1000: elsif po_header_num is not null then
1001: l_from_clause:=l_from_clause||',po_headers_all poh';
1002: l_where_clause:=l_where_clause||' and per_asg.po_header_id=poh.po_header_id'
1003: ||' and upper(poh.segment1) like ('''||upper(replace(po_header_num,g_quote,g_quote||g_quote))||''')';
1004: l_asg:=TRUE;
1005: end if;

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

2456: ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2460: ,po_header_num in po_headers_all.segment1%TYPE default null
2461: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2462: ,po_line_num in po_lines_all.line_num%TYPE default null
2463: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2464: --

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

2457: ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
2458: ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
2459: ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
2460: ,po_header_num in po_headers_all.segment1%TYPE default null
2461: ,po_header_id in po_headers_all.po_header_id%TYPE default null
2462: ,po_line_num in po_lines_all.line_num%TYPE default null
2463: ,po_line_id in po_lines_all.po_line_id%TYPE default null
2464: --
2465: ,first_name in per_all_people_f.first_name%type default null