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 7552: -- view po_temp_labor_headers_v

7548: -- ISSUE : Shared memory size 2,413,494
7549: -- RESOLUTION:
7550: -- 1.Since we are interested only in poh.segment1 we can
7551: -- drop the rest of the columns and unwanted WHERE clauses from the
7552: -- view po_temp_labor_headers_v
7553: -- 2. The SQL below we have retained all the WHERE clauses
7554: -- dealing with the table po_headers_all, but dropped the rest
7555: -- which are not required in this case.
7556:

Line 7582: --from po_temp_labor_headers_v

7578: AND polt.purchase_basis = 'TEMP LABOR'
7579: );
7580:
7581: --select po_number
7582: --from po_temp_labor_headers_v
7583: --where po_header_id = p_id;
7584:
7585:
7586: l_po_number po_temp_labor_headers_v.po_number%TYPE;

Line 7586: l_po_number po_temp_labor_headers_v.po_number%TYPE;

7582: --from po_temp_labor_headers_v
7583: --where po_header_id = p_id;
7584:
7585:
7586: l_po_number po_temp_labor_headers_v.po_number%TYPE;
7587: l_proc varchar2(72) := g_package||'get_po_number';
7588:
7589: BEGIN
7590: hr_utility.set_location('Entering:'||l_proc, 5);