DBA Data[Home] [Help]

APPS.PER_POSITIONS_PKG dependencies on PER_ALL_POSITIONS

Line 38: FROM PER_ALL_POSITIONS PST

34: l_dummy varchar2(1);
35: l_bool boolean;
36: cursor csr_p is
37: SELECT '1'
38: FROM PER_ALL_POSITIONS PST
39: WHERE (PST.ROWID <> p_Rowid
40: OR p_Rowid IS NULL)
41: AND PST.POSITION_ID = p_Position_Id;
42: begin

Line 61: FROM PER_ALL_POSITIONS PST

57: l_dummy varchar2(1);
58: l_bool boolean;
59: cursor csr_pd is
60: SELECT '1'
61: FROM PER_ALL_POSITIONS PST
62: WHERE (PST.ROWID <> p_Rowid
63: OR p_Rowid IS NULL)
64: AND PST.POSITION_DEFINITION_ID = p_Position_Definition_Id
65: AND PST.business_group_id + 0 = p_Business_Group_Id;

Line 420: CURSOR C IS SELECT rowid FROM PER_ALL_POSITIONS

416: X_Attribute20 VARCHAR2,
417: X_View_All_Psts VARCHAR2,
418: X_Security_Profile_id NUMBER
419: ) IS
420: CURSOR C IS SELECT rowid FROM PER_ALL_POSITIONS
421:
422: WHERE position_id = X_Position_Id;
423:
424: