APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PO_TEMP_LABOR_HEADERS_V

Line 662: -- view po_temp_labor_headers_v

658: -- ISSUE : Shared memory size 2,413,494
659: -- RESOLUTION:
660: -- 1.Since we are interested only in poh.segment1 we can
661: -- drop the rest of the columns and unwanted WHERE clauses from the
662: -- view po_temp_labor_headers_v
663: -- 2. The SQL below we have retained all the WHERE clauses
664: -- dealing with the table po_headers_all, but dropped the rest
665: -- which are not required in this case.
666:

Line 692: --from po_temp_labor_headers_v

688: AND polt.purchase_basis = 'TEMP LABOR'
689: );
690:
691: --select po_number
692: --from po_temp_labor_headers_v
693: --where po_header_id = p_id;
694:
695: cursor csr_po_line_number(p_id in number) is
696: select line_number

Line 8035: -- view po_temp_labor_headers_v

8031: -- ISSUE : Shared memory size 2,413,494
8032: -- RESOLUTION:
8033: -- 1.Since we are interested only in poh.segment1 we can
8034: -- drop the rest of the columns and unwanted WHERE clauses from the
8035: -- view po_temp_labor_headers_v
8036: -- 2. The SQL below we have retained all the WHERE clauses
8037: -- dealing with the table po_headers_all, but dropped the rest
8038: -- which are not required in this case.
8039:

Line 8065: --from po_temp_labor_headers_v

8061: AND polt.purchase_basis = 'TEMP LABOR'
8062: );
8063:
8064: --select po_number
8065: --from po_temp_labor_headers_v
8066: --where po_header_id = p_id;
8067:
8068:
8069: l_po_number po_temp_labor_headers_v.po_number%TYPE;

Line 8069: l_po_number po_temp_labor_headers_v.po_number%TYPE;

8065: --from po_temp_labor_headers_v
8066: --where po_header_id = p_id;
8067:
8068:
8069: l_po_number po_temp_labor_headers_v.po_number%TYPE;
8070: l_proc varchar2(72) := g_package||'get_po_number';
8071:
8072: BEGIN
8073: hr_utility.set_location('Entering:'||l_proc, 5);