APPS.FA_LEASE_PVT dependencies on FA_LEASE_SCHEDULES

Line 84: P_PAYMENT_SCHEDULE_ID IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,

80: ---------------------------------------
81: -- CHECK FOR PAYMENT SCHEDULE ID
82: ---------------------------------------
83: FUNCTION CHECK_PAYMENT_SCHEDULE_ID (
84: P_PAYMENT_SCHEDULE_ID IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,
85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
86:
87: CURSOR C_PAYMENT_SCHEDULE_ID IS
88: SELECT PAYMENT_SCHEDULE_ID

Line 89: FROM FA_LEASE_SCHEDULES

85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
86:
87: CURSOR C_PAYMENT_SCHEDULE_ID IS
88: SELECT PAYMENT_SCHEDULE_ID
89: FROM FA_LEASE_SCHEDULES
90: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID;
91:
92: L_PAYMENT_SCHEDULE_ID FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID%TYPE:=NULL;
93:

Line 121: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,

117: ----------------------------------------
118: -- CHECK FOR PAYMENT SCHEDULE NAME
119: ----------------------------------------
120: FUNCTION CHECK_PAYMENT_SCHEDULE_NAME (
121: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
122: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,
123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
124:
125: CURSOR C_PAYMENT_SCHEDULE_NAME IS

Line 122: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,

118: -- CHECK FOR PAYMENT SCHEDULE NAME
119: ----------------------------------------
120: FUNCTION CHECK_PAYMENT_SCHEDULE_NAME (
121: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
122: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE,
123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
124:
125: CURSOR C_PAYMENT_SCHEDULE_NAME IS
126: SELECT PAYMENT_SCHEDULE_ID

Line 127: FROM FA_LEASE_SCHEDULES

123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
124:
125: CURSOR C_PAYMENT_SCHEDULE_NAME IS
126: SELECT PAYMENT_SCHEDULE_ID
127: FROM FA_LEASE_SCHEDULES
128: WHERE PAYMENT_SCHEDULE_NAME = P_PAYMENT_SCHEDULE_NAME;
129:
130: L_PAYMENT_SCHEDULE_ID NUMBER:=NULL;
131:

Line 492: FROM FA_LEASE_SCHEDULES

488: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
489:
490: CURSOR C_CURRENCY_CODE IS
491: SELECT CURRENCY_CODE
492: FROM FA_LEASE_SCHEDULES
493: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID;
494:
495: L_CURRENCY_CODE VARCHAR2(5):=NULL;
496:

Line 817: FROM FA_LEASE_SCHEDULES

813: L_LESSOR_SITE_ORG_ID NUMBER:=NULL;
814:
815: CURSOR C_PRESENT_VALUE IS
816: SELECT PRESENT_VALUE
817: FROM FA_LEASE_SCHEDULES
818: WHERE PAYMENT_SCHEDULE_ID= L_PAYMENT_SCHEDULE_ID;
819:
820: PRESENT_VALUE_NOT_FOUND EXCEPTION;
821: