APPS.PER_ASG_BUS3 dependencies on PO_TEMP_LABOR_LINES_V

Line 1324: FROM po_temp_labor_lines_v pol

1320: WHERE poh.po_header_id = p_po_header_id
1321: AND poh.business_group_id = p_business_group_id
1322: AND EXISTS
1323: (SELECT NULL
1324: FROM po_temp_labor_lines_v pol
1325: WHERE pol.po_header_id = p_po_header_id
1326: AND NOT EXISTS
1327: (SELECT NULL
1328: FROM per_all_assignments_f paaf

Line 1484: FROM po_temp_labor_lines_v pol

1480: -- matches the job, is performed in cross validation chk routines.
1481: --
1482: CURSOR csr_chk_po_line_id IS
1483: SELECT pol.po_line_id
1484: FROM po_temp_labor_lines_v pol
1485: WHERE pol.po_line_id = p_po_line_id
1486: AND NOT EXISTS
1487: (SELECT NULL
1488: FROM per_all_assignments_f paaf

Line 1872: FROM po_temp_labor_lines_v pol

1868: -- PO.
1869: --
1870: CURSOR csr_chk_po_for_line IS
1871: SELECT pol.po_header_id
1872: FROM po_temp_labor_lines_v pol
1873: WHERE pol.po_header_id = p_po_header_id;
1874:
1875: BEGIN
1876:

Line 2100: FROM po_temp_labor_lines_v pol

2096: -- Fetch the job for this PO line.
2097: --
2098: CURSOR csr_chk_po_job_match IS
2099: SELECT NVL(pol.job_id, hr_api.g_number) job_id
2100: FROM po_temp_labor_lines_v pol
2101: WHERE pol.po_line_id = p_po_line_id;
2102:
2103: BEGIN
2104: