APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_NEG_TEAM_MEMBERS

Line 529: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format

525: -- award approval is required;
526: -- Permissible values are Y or N
527: --
528: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
529: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
530: --
531: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
532: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
533: --

Line 532: -- the PON_NEG_TEAM_MEMBERS.USER_ID format

528: -- IN : p_user_name VARCHAR2 Required, user name of the caller in
529: -- the PON_NEG_TEAM_MEMBERS.USER_NAME format
530: --
531: -- IN : p_mgr_id NUMBER Required, manager id of the caller in
532: -- the PON_NEG_TEAM_MEMBERS.USER_ID format
533: --
534: -- IN : p_retain_clause VARCHAR2 Required, flag to carry forward the
535: -- Contracts related information;
536: -- Permissible values are Y or N

Line 6198: FROM PON_NEG_TEAM_MEMBERS PNTM,

6194: l_last_amendment_update,
6195: l_modified_flag,
6196: l_last_notif_date,
6197: l_auc_business_group_id
6198: FROM PON_NEG_TEAM_MEMBERS PNTM,
6199: FND_USER U,
6200: PER_ALL_PEOPLE_F P,
6201: PER_ALL_ASSIGNMENTS_F A,
6202: PER_ALL_POSITIONS S,

Line 6405: PON_NEG_TEAM_MEMBERS

6401: -- Insert data
6402: --
6403: FORALL x IN 1..l_user_id.COUNT
6404: INSERT INTO
6405: PON_NEG_TEAM_MEMBERS
6406: (
6407: AUCTION_HEADER_ID,
6408: LIST_ID,
6409: USER_ID,

Line 6467: FROM PON_NEG_TEAM_MEMBERS PNTM,

6463: BULK COLLECT
6464: INTO
6465: l_full_name
6466: FROM (SELECT PNTM.USER_ID, P.FULL_NAME
6467: FROM PON_NEG_TEAM_MEMBERS PNTM,
6468: FND_USER U, PER_ALL_PEOPLE_F P
6469: WHERE U.USER_ID = PNTM.USER_ID
6470: AND PNTM.AUCTION_HEADER_ID = p_source_auction_header_id
6471: AND PNTM.MEMBER_TYPE = 'N'

Line 6475: FROM PON_NEG_TEAM_MEMBERS PNTM,

6471: AND PNTM.MEMBER_TYPE = 'N'
6472: AND P.PERSON_ID = U.EMPLOYEE_ID
6473: MINUS
6474: SELECT PNTM.USER_ID, P.FULL_NAME
6475: FROM PON_NEG_TEAM_MEMBERS PNTM,
6476: FND_USER U, PER_ALL_PEOPLE_F P
6477: WHERE U.USER_ID = PNTM.USER_ID
6478: AND PNTM.AUCTION_HEADER_ID = p_auction_header_id
6479: AND P.PERSON_ID = U.EMPLOYEE_ID);

Line 11461: pon_neg_team_members new_collab

11457: FROM
11458: pon_scoring_team_members old_members,
11459: pon_scoring_teams old_team,
11460: pon_scoring_teams new_team,
11461: pon_neg_team_members new_collab
11462: WHERE
11463: new_team.auction_header_id = p_auction_header_id
11464: AND old_team.team_id = new_team.orig_team_id
11465: AND old_members.team_id = old_team.team_id