APPS.PA_CONTROL_API_PVT dependencies on PA_LOOKUPS

Line 88: pa_lookups pl

84: --pci.project_id project_id
85: from
86: pa_control_items pci,
87: pa_ci_impact_type_usage pcit,
88: pa_lookups pl
89: where pci.ci_type_id = pcit.ci_type_id
90: and pl.lookup_type = 'PA_CI_IMPACT_TYPES'
91: and decode(pcit.impact_type_code, 'FINPLAN_COST', 'FINPLAN', 'FINPLAN_REVENUE', 'FINPLAN', pcit.impact_type_code) = pl.lookup_code
92: and pl.enabled_flag = 'Y'

Line 1710: FROM pa_lookups

1706:
1707: cursor validate_priority_code(p_priority_code varchar2)
1708: is
1709: select lookup_code
1710: FROM pa_lookups
1711: WHERE lookup_type='PA_TASK_PRIORITY_CODE'
1712: and trunc(sysdate) < nvl(trunc(end_date_active), trunc(sysdate+1))
1713: and enabled_flag = 'Y'
1714: and (trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate)))

Line 1720: FROM pa_lookups

1716:
1717: cursor validate_eff_lvl_code(p_effort_level_code varchar2)
1718: is
1719: select lookup_code
1720: FROM pa_lookups
1721: WHERE lookup_type='PA_CI_EFFORT_LEVELS'
1722: and trunc(sysdate) < nvl(trunc(end_date_active), trunc(sysdate+1))
1723: and enabled_flag = 'Y'
1724: and (trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate)))

Line 1793: l_source_type_name pa_lookups.meaning%type;

1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;

Line 2617: pa_lookups pl

2613: p.employee_number,
2614: p.party_id
2615: FROM pa_people_lov_v p,
2616: fnd_lookups l,
2617: pa_lookups pl
2618: WHERE l.lookup_type='YES_NO'
2619: AND l.lookup_code=DECODE(p.resource_type_id, 101, 'Y', 'N')
2620: AND pl.lookup_type(+) = 'PA_PERSON_TYPE'
2621: AND pl.lookup_code(+) = p.person_type

Line 2758: from pa_lookups

2754: IS
2755:
2756: cursor chk_act_typ_code(p_action_type_code varchar2)
2757: is select lookup_code, meaning
2758: from pa_lookups
2759: where lookup_type ='PA_CI_ACTION_TYPES'
2760: and meaning = p_action_type_code;
2761:
2762: cursor check_valid_src_ci_action_id(p_action_id number) is