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
86:
87: ) RETURN BOOLEAN AS
88:

Line 91: FROM FA_LEASE_SCHEDULES

87: ) RETURN BOOLEAN AS
88:
89: CURSOR C_PAYMENT_SCHEDULE_ID IS
90: SELECT PAYMENT_SCHEDULE_ID
91: FROM FA_LEASE_SCHEDULES
92: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID;
93:
94: L_PAYMENT_SCHEDULE_ID FA_LEASE_PAYMENTS.PAYMENT_SCHEDULE_ID%TYPE:=NULL;
95:

Line 122: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,

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

Line 123: X_PAYMENT_SCHEDULE_ID OUT NOCOPY FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_ID%TYPE

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

Line 129: FROM FA_LEASE_SCHEDULES

125: ) RETURN BOOLEAN AS
126:
127: CURSOR C_PAYMENT_SCHEDULE_NAME IS
128: SELECT PAYMENT_SCHEDULE_ID
129: FROM FA_LEASE_SCHEDULES
130: WHERE PAYMENT_SCHEDULE_NAME = P_PAYMENT_SCHEDULE_NAME;
131:
132: L_PAYMENT_SCHEDULE_ID NUMBER:=NULL;
133:

Line 492: FROM FA_LEASE_SCHEDULES

488: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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 811: FROM FA_LEASE_SCHEDULES

807: L_LESSOR_SITE_ORG_ID NUMBER:=NULL;
808:
809: CURSOR C_PRESENT_VALUE IS
810: SELECT PRESENT_VALUE
811: FROM FA_LEASE_SCHEDULES
812: WHERE PAYMENT_SCHEDULE_ID= L_PAYMENT_SCHEDULE_ID;
813:
814: PRESENT_VALUE_NOT_FOUND EXCEPTION;
815: