APPS.PA_PARLBLDG_XMLP_PKG dependencies on PA_RESOURCES

Line 45: FROM pa_resources;

41:
42: IF (p_start_resource_name IS NULL ) THEN
43: SELECT MIN(name)
44: INTO p_start_resource_name
45: FROM pa_resources;
46: END IF;
47:
48: IF (p_end_resource_name IS NULL ) THEN
49: SELECT MAX(name)

Line 51: FROM pa_resources;

47:
48: IF (p_end_resource_name IS NULL ) THEN
49: SELECT MAX(name)
50: INTO p_end_resource_name
51: FROM pa_resources;
52: END IF;
53: BEGIN
54: SELECT SYSDATE
55: INTO l_date

Line 87: FROM pa_resources

83:
84: ELSIF (UPPER(p_run_mode) = 'S' ) THEN
85: SELECT name
86: INTO l_name
87: FROM pa_resources
88: WHERE resource_id = p_resource_id;
89: p_start_resource_name := l_name;
90: p_end_resource_name := l_name;
91: