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 1693: FROM pa_lookups

1689:
1690: cursor validate_priority_code(p_priority_code varchar2)
1691: is
1692: select lookup_code
1693: FROM pa_lookups
1694: WHERE lookup_type='PA_TASK_PRIORITY_CODE'
1695: and trunc(sysdate) < nvl(trunc(end_date_active), trunc(sysdate+1))
1696: and enabled_flag = 'Y'
1697: and (trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate)))

Line 1703: FROM pa_lookups

1699:
1700: cursor validate_eff_lvl_code(p_effort_level_code varchar2)
1701: is
1702: select lookup_code
1703: FROM pa_lookups
1704: WHERE lookup_type='PA_CI_EFFORT_LEVELS'
1705: and trunc(sysdate) < nvl(trunc(end_date_active), trunc(sysdate+1))
1706: and enabled_flag = 'Y'
1707: and (trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate)))

Line 1776: l_source_type_name pa_lookups.meaning%type;

1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;
1774:
1775:
1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;

Line 2600: pa_lookups pl

2596: p.employee_number,
2597: p.party_id
2598: FROM pa_people_lov_v p,
2599: fnd_lookups l,
2600: pa_lookups pl
2601: WHERE l.lookup_type='YES_NO'
2602: AND l.lookup_code=DECODE(p.resource_type_id, 101, 'Y', 'N')
2603: AND pl.lookup_type(+) = 'PA_PERSON_TYPE'
2604: AND pl.lookup_code(+) = p.person_type

Line 2741: from pa_lookups

2737: IS
2738:
2739: cursor chk_act_typ_code(p_action_type_code varchar2)
2740: is select lookup_code, meaning
2741: from pa_lookups
2742: where lookup_type ='PA_CI_ACTION_TYPES'
2743: and meaning = p_action_type_code;
2744:
2745: cursor check_valid_src_ci_action_id(p_action_id number) is