DBA Data[Home] [Help]

APPS.FA_CACHE_PKG dependencies on FA_CEILINGS

Line 1095: FROM fa_ceilings cur_one,

1091: fazccl_record := fazccl_table(l_count);
1092: else
1093: SELECT cur_one.limit
1094: INTO fazccl_record.ceiling
1095: FROM fa_ceilings cur_one,
1096: fa_ceilings this_one,
1097: fa_ceilings next_one
1098: WHERE cur_one.ceiling_name = X_target_ceiling_name
1099: AND this_one.ceiling_name = X_target_ceiling_name

Line 1096: fa_ceilings this_one,

1092: else
1093: SELECT cur_one.limit
1094: INTO fazccl_record.ceiling
1095: FROM fa_ceilings cur_one,
1096: fa_ceilings this_one,
1097: fa_ceilings next_one
1098: WHERE cur_one.ceiling_name = X_target_ceiling_name
1099: AND this_one.ceiling_name = X_target_ceiling_name
1100: AND next_one.ceiling_name (+) = X_target_ceiling_name

Line 1097: fa_ceilings next_one

1093: SELECT cur_one.limit
1094: INTO fazccl_record.ceiling
1095: FROM fa_ceilings cur_one,
1096: fa_ceilings this_one,
1097: fa_ceilings next_one
1098: WHERE cur_one.ceiling_name = X_target_ceiling_name
1099: AND this_one.ceiling_name = X_target_ceiling_name
1100: AND next_one.ceiling_name (+) = X_target_ceiling_name
1101: AND to_date (X_target_jdate, 'J') BETWEEN