APPS.FPA_MAIN_PROCESS_PVT dependencies on FPA_AW_PC_INFO_V

Line 47: FPA_AW_PC_INFO_V PCS,

43: PCTL.NAME,
44: CC.CLASS_CODE,
45: PCC.CLASS_CATEGORY
46: FROM
47: FPA_AW_PC_INFO_V PCS,
48: FPA_AW_PORTF_HEADERS_V PRTF,
49: FPA_OBJECTS_TL PRTL,
50: FPA_OBJECTS_TL PCTL,
51: PA_CLASS_CATEGORIES PCC,

Line 643: FPA_AW_PC_INFO_V pc

639: pa_project_role_types pprt,
640: per_all_people_f pe,
641: per_all_assignments_f prd,
642: fnd_user u ,
643: FPA_AW_PC_INFO_V pc
644: WHERE ppp.resource_type_id = 101
645: AND ppp.project_role_id = pprt.project_role_id
646: AND ppp.resource_source_id = pe.person_id
647: AND trunc(sysdate) BETWEEN trunc(ppp.start_date_active) AND trunc(NVL(ppp.end_date_active,sysdate))

Line 1573: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1569: l_return_status VARCHAR2(1) := null;
1570: l_msg_count NUMBER := null;
1571: l_msg_data VARCHAR2(2000) := null;
1572: l_pc_id NUMBER := null;
1573: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1574:
1575: BEGIN
1576:
1577: -- Get the Planning Cycle ID

Line 1726: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1722: l_return_status VARCHAR2(1) := null;
1723: l_msg_count NUMBER := null;
1724: l_msg_data VARCHAR2(2000) := null;
1725: l_pc_id NUMBER := null;
1726: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1727:
1728: BEGIN
1729:
1730: -- Get the Planning Cycle ID

Line 1772: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1768: l_return_status VARCHAR2(1) := null;
1769: l_msg_count NUMBER := null;
1770: l_msg_data VARCHAR2(2000) := null;
1771: l_pc_id NUMBER := null;
1772: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1773: l_pc_approve VARCHAR2(1) := null;
1774:
1775: BEGIN
1776:

Line 1846: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1842: l_return_status VARCHAR2(1) := null;
1843: l_msg_count NUMBER := null;
1844: l_msg_data VARCHAR2(2000) := null;
1845: l_pc_id NUMBER := null;
1846: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1847:
1848: BEGIN
1849:
1850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1926: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1922: l_return_status VARCHAR2(1) := null;
1923: l_msg_count NUMBER := null;
1924: l_msg_data VARCHAR2(2000) := null;
1925: l_pc_id NUMBER := null;
1926: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1927:
1928: BEGIN
1929:
1930: -- Get the Planning Cycle ID

Line 1976: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;

1972: l_return_status VARCHAR2(1) := null;
1973: l_msg_count NUMBER := null;
1974: l_msg_data VARCHAR2(2000) := null;
1975: l_pc_id NUMBER := null;
1976: l_pc_status fpa_aw_pc_info_v.pc_status%TYPE := null;
1977:
1978: BEGIN
1979:
1980: -- Get the Planning Cycle ID