DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on PA_PROJECT_ROLE_TYPES_B

Line 51: x_role_party_class pa_project_role_types_b.role_party_class%type; /* Added for Bug 2876924 */

47: l_project_end_date DATE;
48: l_start_date_active DATE;
49: l_msg_index_out NUMBER;
50: x_resource_type_id pa_resources.resource_type_id%type; -- added for bug 2636791
51: x_role_party_class pa_project_role_types_b.role_party_class%type; /* Added for Bug 2876924 */
52: l_key_member_start_date DATE; -- Added for bug 2686120
53: l_check_id_flag VARCHAR2(1); -- Added for bug 4947618
54: l_end_date_active DATE;--Bug 6935585
55: BEGIN

Line 211: from pa_project_role_types_b

207: Hence including a check that role party class should not be 'PERSON'
208: before start date is defaulted to sysdate */
209:
210: select role_party_class into x_role_party_class
211: from pa_project_role_types_b
212: where project_role_id = l_project_role_id;
213:
214: END IF; /* Bug 3116962 */
215: