APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_LOOKUPS

Line 1297: pa_lookups sp,

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

Line 1298: pa_lookups fcst,

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

Line 1311: FROM pa_lookups plks

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

Line 1634: l_staffing_priority_name pa_lookups.meaning%TYPE;

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

Line 1664: FROM pa_lookups

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

Line 1717: FROM pa_lookups

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

Line 1946: FROM pa_lookups

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

Line 2122: FROM pa_lookups

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