APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_LOOKUPS

Line 1312: l_priority_name pa_lookups.meaning%TYPE;

1308: email_address VARCHAR2(2000);
1309: notification_preference VARCHAR2(2000);
1310: language VARCHAR2(2000);
1311: territory VARCHAR2(2000);
1312: l_priority_name pa_lookups.meaning%TYPE;
1313: l_comment_text pa_ci_comments.comment_text%TYPE;
1314: l_loop_var1 NUMBER := 1;
1315: l_record_version_number NUMBER;
1316: l_ci_owner_id pa_control_items.owner_id%TYPE;

Line 1347: pa_lookups pl,

1343: pcb.ci_type_class_code
1344: FROM pa_control_items pci,
1345: pa_ci_types_tl pct,
1346: pa_ci_types_b pcb,
1347: pa_lookups pl,
1348: pa_class_codes pcc
1349: WHERE ci_id = p_ci_id
1350: and pci.ci_type_id = pct.ci_type_id
1351: and pl.lookup_code = pcb.ci_type_class_code

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

1431: and papf.person_id = fu.employee_id;
1432: --);
1433:
1434: --This cursor helps to get meaning given the lookup type and code.
1435: Cursor get_lookup_meaning(c_lookup_type pa_lookups.lookup_type%TYPE, c_lookup_code pa_lookups.lookup_code%TYPE)
1436: IS
1437: Select
1438: lkp.meaning
1439: from

Line 1440: pa_lookups lkp

1436: IS
1437: Select
1438: lkp.meaning
1439: from
1440: pa_lookups lkp
1441: where
1442: lkp.lookup_type = c_lookup_type
1443: and lkp.lookup_code = c_lookup_code;
1444: