APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_LOOKUPS

Line 1415: l_priority_name pa_lookups.meaning%TYPE;

1411: email_address VARCHAR2(2000);
1412: notification_preference VARCHAR2(2000);
1413: language VARCHAR2(2000);
1414: territory VARCHAR2(2000);
1415: l_priority_name pa_lookups.meaning%TYPE;
1416: l_comment_text pa_ci_comments.comment_text%TYPE;
1417: l_loop_var1 NUMBER := 1;
1418: l_record_version_number NUMBER;
1419: l_ci_owner_id pa_control_items.owner_id%TYPE;

Line 1459: pa_lookups pl,

1455: pcb.ci_type_class_code
1456: FROM pa_control_items pci,
1457: pa_ci_types_tl pct,
1458: pa_ci_types_b pcb,
1459: pa_lookups pl,
1460: pa_class_codes pcc
1461: WHERE ci_id = p_ci_id
1462: and pci.ci_type_id = pct.ci_type_id
1463: and pl.lookup_code = pcb.ci_type_class_code

Line 1548: Cursor get_lookup_meaning(c_lookup_type pa_lookups.lookup_type%TYPE, c_lookup_code pa_lookups.lookup_code%TYPE)

1544: and papf.person_id = fu.employee_id;
1545: --);
1546:
1547: --This cursor helps to get meaning given the lookup type and code.
1548: Cursor get_lookup_meaning(c_lookup_type pa_lookups.lookup_type%TYPE, c_lookup_code pa_lookups.lookup_code%TYPE)
1549: IS
1550: Select
1551: lkp.meaning
1552: from

Line 1553: pa_lookups lkp

1549: IS
1550: Select
1551: lkp.meaning
1552: from
1553: pa_lookups lkp
1554: where
1555: lkp.lookup_type = c_lookup_type
1556: and lkp.lookup_code = c_lookup_code;
1557: