APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_LOOKUPS

Line 1298: pa_lookups sp,

1294: asgn.transfer_pr_rate_curr
1295: FROM pa_project_assignments asgn,
1296: pa_projects_all proj,
1297: pa_project_role_types prt,
1298: pa_lookups sp,
1299: pa_lookups fcst,
1300: pa_work_types_v wt
1301: WHERE assignment_id = p_assignment_id
1302: AND asgn.project_role_id = prt.project_role_id

Line 1299: pa_lookups fcst,

1295: FROM pa_project_assignments asgn,
1296: pa_projects_all proj,
1297: pa_project_role_types prt,
1298: pa_lookups sp,
1299: pa_lookups fcst,
1300: pa_work_types_v wt
1301: WHERE assignment_id = p_assignment_id
1302: AND asgn.project_role_id = prt.project_role_id
1303: AND asgn.project_id = proj.project_id

Line 1312: FROM pa_lookups plks

1308: AND asgn.work_type_id = wt.work_type_id;
1309:
1310: CURSOR csr_get_override_basis_name (p_override_basis_code IN VARCHAR2) IS
1311: SELECT plks.meaning
1312: FROM pa_lookups plks
1313: WHERE plks.lookup_type = 'CC_MARKUP_BASE_CODE'
1314: AND plks.lookup_code = p_override_basis_code;
1315:
1316: --cursor to get attributes of the project to be

Line 1635: l_staffing_priority_name pa_lookups.meaning%TYPE;

1631: , p_insert_audit_flag IN VARCHAR2 := 'T'
1632: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1633: ) IS
1634:
1635: l_staffing_priority_name pa_lookups.meaning%TYPE;
1636: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
1637: l_index NUMBER;
1638: l_encoded_message_text VARCHAR2(2000);
1639: l_msg_index_out NUMBER;

Line 1665: FROM pa_lookups

1661: --
1662: IF p_action_status_code = 'PENDING' THEN
1663:
1664: SELECT meaning INTO l_staffing_priority_name
1665: FROM pa_lookups
1666: WHERE lookup_type = 'STAFFING_PRIORITY_CODE'
1667: AND lookup_code = p_staffing_priority_code;
1668:
1669: -- Update the staffing priority code

Line 1718: FROM pa_lookups

1714: IF p_insert_audit_flag = 'T' THEN
1715:
1716: -- Get the Audit Display Attribute
1717: SELECT meaning INTO l_update_sp_display_attribute
1718: FROM pa_lookups
1719: WHERE lookup_type = 'ADVERTISEMENT'
1720: AND lookup_code = 'NO_ACTION_PERFORMED';
1721:
1722: -- insert into into the global audit record

Line 1947: FROM pa_lookups

1943: IF l_action_set_line_id_tbl.COUNT = 0 THEN
1944:
1945: -- Get the Audit Display Attribute
1946: SELECT meaning INTO l_remove_adv_display_attribute
1947: FROM pa_lookups
1948: WHERE lookup_type = 'ADVERTISEMENT'
1949: AND lookup_code = 'NO_ACTION_PERFORMED';
1950:
1951: ELSE

Line 2123: FROM pa_lookups

2119: l_audit_action_code := 'REVERSE_UPDATE_SP';
2120:
2121: -- Get the Audit Display Attribute
2122: SELECT meaning INTO l_update_sp_display_attribute
2123: FROM pa_lookups
2124: WHERE lookup_type = 'ADVERTISEMENT'
2125: AND lookup_code = 'NO_ACTION_PERFORMED';
2126:
2127: ELSE